update data in mail merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kathleane - 09 Nov 2007 22:35 GMT

I'm using MS Office 2003 w XP Home.
I have a mail merge doc set up in Word to print to labels which is linked to
a range in Excel. This document has printed fine and I've been very happy
with it until I make changes to the data in the Excel range. I save the
workbook w those changes but those changes are not reflected in the Word
label doc which still shows old addresses and names that are no longer in the
range. Some address lines show as blanks in the Word doc when there is an
address in the Excel range. I checked the range and it contains the correct
cells. Does anyone know how I can get the updated names and addresses to
merge to my label doc?

Reply to this Message

Graham Mayor - 10 Nov 2007 07:42 GMT

Re-attach the data to the merge document and merge again
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

Signature

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

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

> I'm using MS Office 2003 w XP Home.
> I have a mail merge doc set up in Word to print to labels which is
[quoted text clipped - 7 lines]
> how I can get the updated names and addresses to merge to my label
> doc?

Reply to this Message