It did not work.
OK, if you can describe what happened, that might be useful. But if not,
there's another thing we can try...
Open your mail merge main document and use File-Save As to save the file in
HTML format. Then open the .htm file using e.g. Notepad and look for a chunk
of text that starts with this (it should be fairly near the top of the
file):
w:MailMergeMainDocType
Then copy/paste, say, the next 20 lines into a message in this conversation.
--
Peter Jamieson
http://tips.pjmsn.me.uk
"Courtney" wrote in message
...
Peter, Yes the 2008 and 2009 sheets are definitely different files. I
went
into the Word VBA and copy/paste the info given. It did not work. I
should
have mentioned earlier I am working with Office Word 2003.
"Peter Jamieson" wrote:
Which version of Word/Excel?
Are the 2008 and 2009 sheets definitely different files and not two
worksheets in the same workbook?
With your mailmerge main document open, can you go into Word VBA, open
the
Immediate panel if it is not displayed (e.g. press ctrl-G in the VBA
editor)
and type the following commands, and copy/paste the output in a message
in
this conversation:
print activedocument.mailmerge.datasource.name
print activedocument.mailmerge.datasource.connectstring
print activedocument.mailmerge.datasource.querystring
--
Peter Jamieson
http://tips.pjmsn.me.uk
"Courtney" wrote in message
...
I am having issues with the mail merge pulling in the wrong excel data.
In
the mail merge menu I browse for and select a 2009 file. When the mail
merge
automatically opens the file in excel it opens the correct file, 2009.
However when it gets to the step of selecting a named or cell range I
select
I am getting a range for the 2008 file and not the 2009 file.
Does anyone have any ideas why it is pulling the 2008 file and not the
2009
file?