word mail merge excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nora - 11 Aug 2006 23:02 GMT

I have an word letter merged to an excel file that does not exist any more. I
have created a new excel file. How do I change the data source in OFFICE
2003. It used to work very easily in Word 2000. What is different? This is
a rush. Help!!

Reply to this Message

Doug Robbins - Word MVP - 12 Aug 2006 05:02 GMT

In Word, from the View menu, select Toolbars and check the Mail Merge item
to display the mailmerge toolbar. Then use the second button from the left
to attach the (new) data source to the main document.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I have an word letter merged to an excel file that does not exist any more.
>I
> have created a new excel file. How do I change the data source in OFFICE
> 2003. It used to work very easily in Word 2000. What is different? This
> is
> a rush. Help!!

Reply to this Message

Graham Mayor - 12 Aug 2006 05:53 GMT

From the merge toolbar, simply select the new data source (second button
from the left).
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 have an word letter merged to an excel file that does not exist any
> more. I have created a new excel file. How do I change the data
> source in OFFICE 2003. It used to work very easily in Word 2000.
> What is different? This is a rush. Help!!

Reply to this Message