Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / February 2005

Tip: Looking for answers? Try searching our database.

Excel Column Labels and mail merge

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Kevin - 16 Feb 2005 15:26 GMT
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.
Doug Robbins - 16 Feb 2005 23:56 GMT
You should forget about using the Address Block and place the individual
merge fields where you want them.

Signature

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

> Does mail merge support using the labels defined within Excel as the
> Header
[quoted text clipped - 16 lines]
>
> I am using Windows XP, Office XP.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.