Home |
Search |
Today's Posts |
#1
|
|||
|
|||
cannot mail merge from excel to word
I have set up my data in Excel using several worksheets. When I open my Word
document it asks me to "open document in workbook" so I select the specific worksheet that contains my data, and then I select "entire worksheet" for the "name or cell range". I have tried it both with and without the "Format for Mail Merge box checked" with no results. No matter how I map to the excel data the merge will not complete successfully. any help? I know it has found the data because it let me insert the fields from the header row in Excel into the Word document. Microsoft Word 2000 and Microsoft Excel 2000 Thanks ALF2020 |
#2
|
|||
|
|||
cannot mail merge from excel to word
The key here, Alan, is "several worksheet". Word won't merge with "several",
only one... So you either have to do multiple merges (you can use named ranges), or start copying your data onto one worksheet. ************ Anne Troy www.OfficeArticles.com "Alan" wrote in message ... I have set up my data in Excel using several worksheets. When I open my Word document it asks me to "open document in workbook" so I select the specific worksheet that contains my data, and then I select "entire worksheet" for the "name or cell range". I have tried it both with and without the "Format for Mail Merge box checked" with no results. No matter how I map to the excel data the merge will not complete successfully. any help? I know it has found the data because it let me insert the fields from the header row in Excel into the Word document. Microsoft Word 2000 and Microsoft Excel 2000 Thanks ALF2020 |
#3
|
|||
|
|||
cannot mail merge from excel to word
Dear Anne,
Thank you so much...that was easy. Since most of "Office" is intuitive I am rather surprised that it cannot locate data on a specific worksheet when more than one worksheet is present. Sincerely, Alan "Anne Troy" wrote: The key here, Alan, is "several worksheet". Word won't merge with "several", only one... So you either have to do multiple merges (you can use named ranges), or start copying your data onto one worksheet. ************ Anne Troy www.OfficeArticles.com "Alan" wrote in message ... I have set up my data in Excel using several worksheets. When I open my Word document it asks me to "open document in workbook" so I select the specific worksheet that contains my data, and then I select "entire worksheet" for the "name or cell range". I have tried it both with and without the "Format for Mail Merge box checked" with no results. No matter how I map to the excel data the merge will not complete successfully. any help? I know it has found the data because it let me insert the fields from the header row in Excel into the Word document. Microsoft Word 2000 and Microsoft Excel 2000 Thanks ALF2020 |
#4
|
|||
|
|||
cannot mail merge from excel to word
See the Excel section of the article "Creating a Mail Merge Data Source" at:
http://www.word.mvps.org/FAQs/MailMe...DataSource.htm -- 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 "Alan" wrote in message ... I have set up my data in Excel using several worksheets. When I open my Word document it asks me to "open document in workbook" so I select the specific worksheet that contains my data, and then I select "entire worksheet" for the "name or cell range". I have tried it both with and without the "Format for Mail Merge box checked" with no results. No matter how I map to the excel data the merge will not complete successfully. any help? I know it has found the data because it let me insert the fields from the header row in Excel into the Word document. Microsoft Word 2000 and Microsoft Excel 2000 Thanks ALF2020 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a Word form like corel WP merge documents? | Microsoft Word Help | |||
Word Mail Merge using Excel data | New Users | |||
Mail Merge Word document using Excel | Mailmerge | |||
Mail merge Word from Excel | Mailmerge | |||
How do I set sup a mail merge from Excel to Word if the system ca. | Mailmerge |