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!
>.