Excel Column Labels and mail merge

K

Kevin

Does mail merge support using the labels defined within Excel as the Header
field? I would think that it does, but when I attach to the Excel file it
doesn't automatically map, but instead shows me the first record and I have
to then manually map it, i.e.:

John
Doe
1000 Main St
Anytown
IA
50001
....

This isn't the worst thing in the world, but I'd prefer to have MailMerge
recognize the labels as it seems it would streamline the process -- I have
this fields labelled as First Name, Last Name, etc.

I am using Windows XP, Office XP.
 
D

Doug Robbins

You should forget about using the Address Block and place the individual
merge fields where you want them.

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top