From the View menu in Word, select Toolbars and then check the Mail Merge
item.
Then, with your mail merge main document open, click on the Main document
setup button on the toolbar (the one with the page and envelope icon) and
then select Normal Word document in the Main Document Type dialog that will
appear. Save the document, close it and then re-open it and via the Main
document setup button, set the document type to the one that you are wanting
to create. Then click on the next button on the toolbar to select the data
source and see if this then connects to the correct 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
"Courtney" wrote in message
...
Except there is only one worksheet in the file.
"Peter Jamieson" wrote:
When you connect via DDE, you only get to see data on the first worksheet
in
the workbook (it does not matter what range name, cf. Print_Area, you
choose).
Could that be the problem?
--
Peter Jamieson
http://tips.pjmsn.me.uk
"Courtney" wrote in message
...
I tried the file save as method. However, I do not get an option to
save
it
as an HTML format.
Here is what happened.
First I opened the Word document.
Then I clicked on Tools, Letters & Mailings, Mail Merge.
Then the mail merge menu on the right side of the screen comes up and
at
the
bottom I click on Next: Starting Document
Then I click on Next: Select Recipients
Then I click on Browse and select my 2009 file. Then word opens the
excel
document with the 2009 data.
Then the Confirm Data Source box pops up and I click on the MS Excel
Worksheet via DDE (*.xls)
Then in the Microsoft Excel Named or Cell Range box I click on the
Print_Area option then click ok. Prior to opening anything in my excel
file
I have set the print area with no hidden rows or columns.
Then the Mail Merge Recipients box pops up and this is where I stop
because
I can see it contains the wrong data, the data from the 2008 file.
"Peter Jamieson" wrote:
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?