A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Doing Place name cards in mailmerge



 
 
Thread Tools Display Modes
  #1  
Old May 4th, 2005, 05:34 PM
AMCK
external usenet poster
 
Posts: n/a
Default Doing Place name cards in mailmerge

Hi
Am trying to do place name cards. i have the inserts and plastic thingys to
put them in. they are durable 1458. everything is set out, the label is on
the list in word but when i merge it, the name appears on the card in the
wrong place, ie. not in the middle. also and most annoyingly, it does not
give you an option of doing the label on the reverse side??? which is the
whole purpose you are using this type of label?? i do not get it! anyone out
there that can explain please?
  #2  
Old May 4th, 2005, 08:52 PM
Charles Kenyon
external usenet poster
 
Posts: n/a
Default

I suspect that the simplest way will be to do two runs through your printer.
The only formatting a label merge knows is to put things in the top left of
each cell. So, merge to a new document and do your formatting in the new
document. If it will work, run the forms through your printer twice. (Do
this on plain paper first, to save on the cost of errors.) Otherwise...

Not as a merge, create a new document based on the label format. This will
be a table. It will be a starting place for you to look at. Make sure you
have gridlines displayed.

Now create yet another new document, this time in landscape mode. Set it up
to have the same table arrangement as the other document, except sideways.
In this document you will be able to rotate the text in the table cells by
90 degrees clockwise or counterclockwise. Put merge fields in these rotated
cells with your fields. Format them the way you want.

Good luck.
--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

"AMCK" wrote in message
...
Hi
Am trying to do place name cards. i have the inserts and plastic thingys
to
put them in. they are durable 1458. everything is set out, the label is on
the list in word but when i merge it, the name appears on the card in the
wrong place, ie. not in the middle. also and most annoyingly, it does not
give you an option of doing the label on the reverse side??? which is the
whole purpose you are using this type of label?? i do not get it! anyone
out
there that can explain please?



  #3  
Old May 5th, 2005, 12:22 PM
AMCK
external usenet poster
 
Posts: n/a
Default

Hi Charles
Thank you for you quick answer. I actually figured out a way! I merged to
new doc. then formatted the text to appear at the bottom of cell and in the
middle. Then printed all the place names...then, cut the names and swapped
them around if you get what i mean!! It worked, albeit risky with the paper!
job done and boss happy so thats all that matters for now! Mind you, I am
surprised there is not a simpler way to do it. Will pen a note to mr. gates!!
THanks again.
AMCK.

"Charles Kenyon" wrote:

I suspect that the simplest way will be to do two runs through your printer.
The only formatting a label merge knows is to put things in the top left of
each cell. So, merge to a new document and do your formatting in the new
document. If it will work, run the forms through your printer twice. (Do
this on plain paper first, to save on the cost of errors.) Otherwise...

Not as a merge, create a new document based on the label format. This will
be a table. It will be a starting place for you to look at. Make sure you
have gridlines displayed.

Now create yet another new document, this time in landscape mode. Set it up
to have the same table arrangement as the other document, except sideways.
In this document you will be able to rotate the text in the table cells by
90 degrees clockwise or counterclockwise. Put merge fields in these rotated
cells with your fields. Format them the way you want.

Good luck.
--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

"AMCK" wrote in message
...
Hi
Am trying to do place name cards. i have the inserts and plastic thingys
to
put them in. they are durable 1458. everything is set out, the label is on
the list in word but when i merge it, the name appears on the card in the
wrong place, ie. not in the middle. also and most annoyingly, it does not
give you an option of doing the label on the reverse side??? which is the
whole purpose you are using this type of label?? i do not get it! anyone
out
there that can explain please?




  #4  
Old May 5th, 2005, 12:43 PM
Graham Mayor
external usenet poster
 
Posts: n/a
Default

It's a bit fiddly to do but you can split the cells and rotate the text in
one of them (or rotate one left and one right as necessary). The method is
that shown in the last section of http://www.gmayor.com/Numbered_labels.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




AMCK wrote:
Hi Charles
Thank you for you quick answer. I actually figured out a way! I
merged to new doc. then formatted the text to appear at the bottom of
cell and in the middle. Then printed all the place names...then, cut
the names and swapped them around if you get what i mean!! It worked,
albeit risky with the paper! job done and boss happy so thats all
that matters for now! Mind you, I am surprised there is not a simpler
way to do it. Will pen a note to mr. gates!! THanks again.
AMCK.

"Charles Kenyon" wrote:

I suspect that the simplest way will be to do two runs through your
printer. The only formatting a label merge knows is to put things in
the top left of each cell. So, merge to a new document and do your
formatting in the new document. If it will work, run the forms
through your printer twice. (Do this on plain paper first, to save
on the cost of errors.) Otherwise...

Not as a merge, create a new document based on the label format.
This will be a table. It will be a starting place for you to look
at. Make sure you have gridlines displayed.

Now create yet another new document, this time in landscape mode.
Set it up to have the same table arrangement as the other document,
except sideways. In this document you will be able to rotate the
text in the table cells by 90 degrees clockwise or counterclockwise.
Put merge fields in these rotated cells with your fields. Format
them the way you want.

Good luck.
--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

"AMCK" wrote in message
...
Hi
Am trying to do place name cards. i have the inserts and plastic
thingys to
put them in. they are durable 1458. everything is set out, the
label is on the list in word but when i merge it, the name appears
on the card in the wrong place, ie. not in the middle. also and
most annoyingly, it does not give you an option of doing the label
on the reverse side??? which is the whole purpose you are using
this type of label?? i do not get it! anyone out
there that can explain please?



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
I would like to make place cards for my wedding, any templates or. Val General Discussion 1 January 15th, 2005 01:53 AM
Included Property in Word 2003 MailMerge Alessio Mailmerge 1 December 23rd, 2004 11:26 AM
Copying a mailmerge document to another computer Boog Mailmerge 3 November 22nd, 2004 08:39 PM
How do I print premade cards in Microsoft Word and centre a photo. Ladyb Page Layout 1 October 13th, 2004 10:59 AM
MailMerge with Send To Postal Code milco Mailmerge 1 June 19th, 2004 08:31 PM


All times are GMT +1. The time now is 01:12 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.