View Single Post
  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Mail Merge - table connection

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

"RR" wrote in message
...
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

"Spoonemore" wrote:

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" wrote:

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