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 / August 2004

Tip: Looking for answers? Try searching our database.

Merge with Excel Mixed Up

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Lisa - 11 Aug 2004 01:31 GMT
Mail merge (labels) performed with Office XP Word and my
customer list from my Windows ME era Excel came out
garbled.  Names and addreses were all switched around.  
Names and addresses not matching.  Is it a software
glitch or was the merge overwhelmed?  My client list is
over 800 people?  Help!
Peter Jamieson - 11 Aug 2004 06:12 GMT
> Is it a software
> glitch or was the merge overwhelmed?

I don't know, but I would certainly try to get my data into an up-to-date
format, just in case, e.g. perhaps
a. create a new spreadsheet
b. cop/paste from the old spreadsheet into the new one.

You could also consider copying/pasting your data into a completely
different format for the purposes of the merge, e.g. copy/paste into a new
Word document.
Signature

Peter Jamieson

> Mail merge (labels) performed with Office XP Word and my
> customer list from my Windows ME era Excel came out
> garbled.  Names and addreses were all switched around.
> Names and addresses not matching.  Is it a software
> glitch or was the merge overwhelmed?  My client list is
> over 800 people?  Help!
Graham Mayor - 11 Aug 2004 06:52 GMT
800 records shouldn't be a problem .See if
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm helps

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor -  Word MVP

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

> Mail merge (labels) performed with Office XP Word and my
> customer list from my Windows ME era Excel came out
> garbled.  Names and addreses were all switched around.
> Names and addresses not matching.  Is it a software
> glitch or was the merge overwhelmed?  My client list is
> over 800 people?  Help!
Suse - 13 Aug 2004 20:26 GMT
Hi Lisa -
I had something like this happen and I had my "next
record" commands in the wrong places.  I was a bit rusty
and was putting "next record" before each word merge
command for example - in each label cell I had:
Next record <name>
Next record <address>
Next record <city,st,zip>
Instead of:
Next record <name>
<address>
<city,st,zip>
Merge was a mess -- I forgot that word looks from row to
row.  Just a thought that you might be doing the same
thing!-- Of course your first label cell you would not
have "next record".
take care & good luck!
Sue
>-----Original Message-----
>Mail merge (labels) performed with Office XP Word and my
[quoted text clipped - 4 lines]
>over 800 people?  Help!
>.

Rate this thread:






 
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.