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 / April 2005

Tip: Looking for answers? Try searching our database.

Problem with mail merge Data

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Stephanie Kelly - 17 Mar 2005 22:33 GMT
I use Office 2002XP

When merging a document from Excel into Word for a Label mail merge the
first row of data becomes the header.  There is a header and the box that
asks that is checked.  Tried deleting the header, unmarking the box, moving
the first row of data.  Nothing seems to work.  
Cindy M  -WordMVP- - 22 Mar 2005 22:31 GMT
Hi =?Utf-8?B?U3RlcGhhbmllIEtlbGx5?=,

I'm not sure I understand. Header, as in View/Header and Footer? Or header as
in repeat the first table row on each new page?

To which box that is checked are you referring (menu command to get there)?

> I use Office 2002XP
>  
> When merging a document from Excel into Word for a Label mail merge the
> first row of data becomes the header.  There is a header and the box that
> asks that is checked.  Tried deleting the header, unmarking the box, moving
> the first row of data.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)
Stephanie Kelly - 04 Apr 2005 21:43 GMT
In Mail Merge wizard after you select the file (the data source) then you go
into the file to select the records to merge (you can sort the data etc in
this step).  This box is taking the first row of data and using it as a
header row.  So instead of "First Name" being the first column it is
"Daniel".  When selecting the data source file there is a box that asks if
the file has a header row, this is checked.  Also tried to unselect the box.  
Also tried to remove the header row in the data source.  The only way I got
around it was to select the whole excel spreadsheet and paste it into a new
book.  I assumed the file was corrupt in some way.  This seemed to work for
me, but if there is an easier answer I would love to hear what you have to
say.  Thank you.

> Hi =?Utf-8?B?U3RlcGhhbmllIEtlbGx5?=,
>
[quoted text clipped - 17 lines]
> This reply is posted in the Newsgroup; please post any follow question or
> reply in the newsgroup and not by e-mail :-)
 
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.