Group:  Microsoft Word ยป microsoft.public.word.mailmerge.fields
Thread: how fix labels merged from excel so name is first and not address

Geek News

how fix labels merged from excel so name is first and not address
mar 12/15/2008 5:37:01 PM
After I setup mail merge to print labels from excel, print preview shows the
street addreas before the name even after I double-check the address match so
please can someone tell me how to fix this and how to get all pages of labels
printed at the same time - not just the first 30 which is the number of
labels on each page.

Thank you,

MaryAnn
Re: how fix labels merged from excel so name is first and not address
"Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 12/15/2008 7:47:52 PM
Instead of using the addressblock field, or bothering with trying the match
your actual field names with those that Word is expecting when using that
field, just insert the actual field names into the label in the
configuration that you want them.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"mar" <mar[ at ]discussions.microsoft.com> wrote in message
news:F69A92DB-9A2C-4961-9359-1293C57926EB[ at ]microsoft.com...
[Quoted Text]
> After I setup mail merge to print labels from excel, print preview shows
> the
> street addreas before the name even after I double-check the address match
> so
> please can someone tell me how to fix this and how to get all pages of
> labels
> printed at the same time - not just the first 30 which is the number of
> labels on each page.
>
> Thank you,
>
> MaryAnn


Home | Search | Terms | Imprint Contact
Newsgroups Reader - provided by WiredBox.Net