Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Problem using excel workbook in word mailmerge
I have not gotten any response from the word mailmerge topic so thought I'd
try here. Problem running a mailmerge with an Excel workbook. Some of the worksheets work, other worksheets bring up the select table a second time and it is blank. There are worksheets for all 12 months. March, May, July, September and November have this problem. The other months are fine. We can select the 'May 05$' in the select table box, then it comes back a second time blank. When we select the 'January 05$' table, the mailmerge is successful. Why do some of the worksheets come up with the select table box a second time? I contacted the originator of the excel workbook and here's what he said: I created all the worksheets the same way. by copying the spreadsheet in the tab labeled "List A-Odd Months" and pasted it into the actual month's tab. Any ideas would be appreciated. |
#2
|
|||
|
|||
Ellen
Check those worksheets for used range by hitting CTRL + END on each one. If below and right of real used range, select all rows below your real range and EditDeleteEntire row. Same for columns to the right. Save the workbook, close and re-open. Try your mailmerge now. For help on Word mail merge using Excel as the data source. http://www.mvps.org/dmcritchie/excel/mailmerg.htm http://www.mvps.org/word/FAQs/MailMe...AMailMerge.htm http://www.mvps.org/word/FAQs/MailMe...DataSource.htm And a training tutorial for creating envelopes and labels. http://office.microsoft.com/training...RC010390291033 Gord Dibben Excel MVP On Mon, 2 May 2005 14:29:11 -0700, "Ellen" wrote: I have not gotten any response from the word mailmerge topic so thought I'd try here. Problem running a mailmerge with an Excel workbook. Some of the worksheets work, other worksheets bring up the select table a second time and it is blank. There are worksheets for all 12 months. March, May, July, September and November have this problem. The other months are fine. We can select the 'May 05$' in the select table box, then it comes back a second time blank. When we select the 'January 05$' table, the mailmerge is successful. Why do some of the worksheets come up with the select table box a second time? I contacted the originator of the excel workbook and here's what he said: I created all the worksheets the same way. by copying the spreadsheet in the tab labeled "List A-Odd Months" and pasted it into the actual month's tab. Any ideas would be appreciated. |
#3
|
|||
|
|||
Gord,
Thank you for the instructions. I sent them onto the person who contacted me with this issue and it worked. "Ellen" wrote: I have not gotten any response from the word mailmerge topic so thought I'd try here. Problem running a mailmerge with an Excel workbook. Some of the worksheets work, other worksheets bring up the select table a second time and it is blank. There are worksheets for all 12 months. March, May, July, September and November have this problem. The other months are fine. We can select the 'May 05$' in the select table box, then it comes back a second time blank. When we select the 'January 05$' table, the mailmerge is successful. Why do some of the worksheets come up with the select table box a second time? I contacted the originator of the excel workbook and here's what he said: I created all the worksheets the same way. by copying the spreadsheet in the tab labeled "List A-Odd Months" and pasted it into the actual month's tab. Any ideas would be appreciated. |
#4
|
|||
|
|||
Thanks for the feedback.
Always nice to hear if a suggestion works or not. Gord On Tue, 3 May 2005 10:50:05 -0700, "Ellen" wrote: Gord, Thank you for the instructions. I sent them onto the person who contacted me with this issue and it worked. "Ellen" wrote: I have not gotten any response from the word mailmerge topic so thought I'd try here. Problem running a mailmerge with an Excel workbook. Some of the worksheets work, other worksheets bring up the select table a second time and it is blank. There are worksheets for all 12 months. March, May, July, September and November have this problem. The other months are fine. We can select the 'May 05$' in the select table box, then it comes back a second time blank. When we select the 'January 05$' table, the mailmerge is successful. Why do some of the worksheets come up with the select table box a second time? I contacted the originator of the excel workbook and here's what he said: I created all the worksheets the same way. by copying the spreadsheet in the tab labeled "List A-Odd Months" and pasted it into the actual month's tab. Any ideas would be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to refresh a Excel workbook with pivot & ADO query report in batch mode | Excel Discussion (Misc queries) | |||
Moving paragraphs from MS Word to Excel | Excel Discussion (Misc queries) | |||
Using Excel workbook as data source for word mailmerge | Excel Discussion (Misc queries) | |||
Macro in Excel 2002 to save a workbook to a FTP location | Excel Discussion (Misc queries) | |||
Hyperlink to word document problem | Links and Linking in Excel |