Mail Merge - table connection

[RR]

I'm trying to create a new set of letters, using a word document which has
had a previous mail merge. I can't get the new excel name-address list
connected to the letter model. It keeps listing the previous table of
name/addresses.
Thought/suggestions?

Thanks,
RR

 

[Spoonemore]

If this answer posts twice, I apologize-I received an error about server
being busy.

What vesion of Office are you on? There should be a 'browse' function to
allow you to change to a different file or database.

Word 2003-using the Mail Merge Wizard, it should be on Step 3 of 6.

Word 2007-when you click to 'select recipients', you click on 'use existing
list'. You should get a display that allows you to search for a different
file or database. It will default 'My Data Source' but you can search other
folders.

 

[RR]

Word 2003
All goes as you outlined. However, after I've selected my excel file from
"My Data Source", I choose a "Table". The content of the table appears to be
the original excel data rather than the updated excel data. It looks like
the "table" (excel data) somehow remains attached to the word document and
does not retrieve the data from the new excel document.

rr

 

[Doug Robbins - Word MVP]

Are you sure that you are selecting the right work sheet as the data source?

You could try in the first step of the mailmerge process, converting the
mail merge main document to a normal Word document (which will remove the
data source completely) and then set it back to a formletter type mail merge
main document and then select the new data source.

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