Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mail merge and document file
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? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mail merge and document file
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? |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mail merge and document file
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? |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mail merge and document file
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? |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mail merge and document file
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? |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mail merge and document file
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 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? |
#7
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mail merge and document file
To save as HTML you should be able to select "Web Page (*.htm, *.html)" in
the "Save as type" dropdown in the Save As dialog box. -- 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 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? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail Merge from inside word document using excel data file | Mailmerge | |||
How do I print the data file for a mail merge document? | Mailmerge | |||
my mail merge tool bar is not active in my mail merge file | Microsoft Word Help | |||
attaching pdf file with main word document in mail merge | Microsoft Word Help | |||
saved main document in mail merge, how do I extract the date file. | Mailmerge |