MobileMobile | Continue

Excel Bar

Excel Bar

Your excel questions will be responsed by our excel experts within 24hrs.Our service is free.

 Forgot Pass?
 Register Now
Find
Hot Search: Vlookup Match VBA
View: 311|Reply: 7

mail merge/table text direction

[Copy link]

1

Topics

1

Posts

9

Integral

Newbie

Rank: 1

Integral
9
Post on 9-30-2016 08:38:56 | All posts |Read mode
So I did a trial run with a mail merge for some labels to create.  The labels are 3.5 x 5 so when i merged them i then had to change the text direction 90 degrees.  here is where the problem is that to turn the text i have to go to each table that is created in the mail merge and turn each one individually.  I've looked and searched all over and not seeing anyway  but figured I am not turning enough stones or clicking enough areas to do what i am needing it to do.  so is there a way to turn them all at once or do i just have to click each one and turn each one, one at a time.




Reply

Props Report

2

Topics

188

Posts

466

Integral

Conqueror

Rank: 3Rank: 3

Integral
466
Post on 9-30-2016 09:16:19 | All posts



Did you try changing the text direction in the mailmerge main document? Having done that, you shouldn't need to do it on the output. Equally, you might get the required results if you used a label template that was itself oriented at 90 degrees (i.e. using a landscape layout instead of a portrait layout).
Reply Support Opposition

Props Report

5

Topics

75

Posts

193

Integral

Conqueror

Rank: 3Rank: 3

Integral
193
Post on 11-11-2016 05:42:09 | All posts



I suggest deleting the background that you don't want to print.











Reply Support Opposition

Props Report

2

Topics

188

Posts

466

Integral

Conqueror

Rank: 3Rank: 3

Integral
466
Post on 11-11-2016 06:28:48 | All posts



Agreed. This really has nothing to do with mailmerge, per se. Once the setup is done, the unwanted background should be deleted from the mailmerge main document before executing the merge - otherwise you might end up having to delete it from every merged record.
Reply Support Opposition

Props Report

7

Topics

551

Posts

1283

Integral

King

Rank: 6Rank: 6

Integral
1283
Post on 2-11-2017 17:29:48 | All posts



Using the literal text from your post...
is there a tutorial on the proper way to do a mail merge




Reply Support Opposition

Props Report

2

Topics

23

Posts

66

Integral

Member

Rank: 2

Integral
66
Post on 2-11-2017 18:03:39 | All posts



Point taken, I just thought this site would have more detailed information not sarcasm




Reply Support Opposition

Props Report

7

Topics

551

Posts

1283

Integral

King

Rank: 6Rank: 6

Integral
1283
Post on 2-11-2017 19:34:48 | All posts



It's not sarcasm.
You posted a very general question best answered with a very general introduction. Otherwise you're really asking someone to take the time to lay out all the ins and outs of a mail merge without knowing your particular requirements so that is something best investigated by yourself in the first place.
If you had said I am trying to do 'x' or 'y' and my data looks like 'z' then comments on the pros and cons of each approach are possible.
This is sarcasm










Reply Support Opposition

Props Report

2

Topics

188

Posts

466

Integral

Conqueror

Rank: 3Rank: 3

Integral
466
Post on 2-11-2017 21:13:51 | All posts



+1
Besides which, since mailmerges are usually run from Word (regardless of the datasource), the question would probably better have been asked in Word Formatting  General: http://www.msofficeforums.com/mail-m...ps-tricks.html
or:
http://windowssecrets.com/forums/sho...ips-amp-Tricks
Reply Support Opposition

Props Report

Points policy of this forum

Archiver|Mobile|Small dark house|Contact us|Excel Bar

GMT-5, 9-24-2017 21:23 , Processed in 0.224893 second(s), 20 queries .

Powered by Discuz! X3

© 2001-2013 Comsenz Inc.

!fastreply! Top !return_list!