Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Help with mail merge
Hi all,
I had an existing 2003 spreadsheet and updated it to a 2007 excel spreadsheet. I am familiar with mail merge, but I cannot get the data to import properly. What am I doing wrong? I tried the Wizard and also tried the manual insertion. The word document was created in Word 2007. Thanks for any help you all might have. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Help with mail merge
You best short-term option in this case is probably to Check Microsoft Office Button|Word Options|Advanced|General|"Confirm File format conversion upon open" Then try reconnecting to your workbook in Mailings|Select Recipients. After you have selected the workbook, you should see the Confirm Data Source dialog box, probably with just the "OLE DB Database Files" option showing. Check "Show all", then select "MS Excel Worksheets via DDE", then OK. Word will open Excel and do the right thing. However, it will only work with the first sheet in your workbook, Unicode data won't come acress and only the first (can't remember how many) columns will come across. But can you describe what went wrong? Did you see any dialog boxes at all? Normally, Word tries OLE DB first, then if it fails, it tries ODBC and unfortunately there may be an error in the ODBC dialog box that prevents you from getting any further. Peter Jamieson "P.J." wrote in message ... Hi all, I had an existing 2003 spreadsheet and updated it to a 2007 excel spreadsheet. I am familiar with mail merge, but I cannot get the data to import properly. What am I doing wrong? I tried the Wizard and also tried the manual insertion. The word document was created in Word 2007. Thanks for any help you all might have. |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Help with mail merge
Thank you Peter,
I did try your suggestions and it seemed it would work. However, when you selected finish the merge, there was nothing inserted. Because of time constraints I had to create a new list from the mailing menu. I believe it is recognising the title fields as text to be merged. When time allows, I will research this. Again, thank you so much. "Peter Jamieson" wrote: You best short-term option in this case is probably to Check Microsoft Office Button|Word Options|Advanced|General|"Confirm File format conversion upon open" Then try reconnecting to your workbook in Mailings|Select Recipients. After you have selected the workbook, you should see the Confirm Data Source dialog box, probably with just the "OLE DB Database Files" option showing. Check "Show all", then select "MS Excel Worksheets via DDE", then OK. Word will open Excel and do the right thing. However, it will only work with the first sheet in your workbook, Unicode data won't come acress and only the first (can't remember how many) columns will come across. But can you describe what went wrong? Did you see any dialog boxes at all? Normally, Word tries OLE DB first, then if it fails, it tries ODBC and unfortunately there may be an error in the ODBC dialog box that prevents you from getting any further. Peter Jamieson "P.J." wrote in message ... Hi all, I had an existing 2003 spreadsheet and updated it to a 2007 excel spreadsheet. I am familiar with mail merge, but I cannot get the data to import properly. What am I doing wrong? I tried the Wizard and also tried the manual insertion. The word document was created in Word 2007. Thanks for any help you all might have. |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Help with mail merge
Will be interested to hear your findings...
Peter Jamieson "P.J." wrote in message ... Thank you Peter, I did try your suggestions and it seemed it would work. However, when you selected finish the merge, there was nothing inserted. Because of time constraints I had to create a new list from the mailing menu. I believe it is recognising the title fields as text to be merged. When time allows, I will research this. Again, thank you so much. "Peter Jamieson" wrote: You best short-term option in this case is probably to Check Microsoft Office Button|Word Options|Advanced|General|"Confirm File format conversion upon open" Then try reconnecting to your workbook in Mailings|Select Recipients. After you have selected the workbook, you should see the Confirm Data Source dialog box, probably with just the "OLE DB Database Files" option showing. Check "Show all", then select "MS Excel Worksheets via DDE", then OK. Word will open Excel and do the right thing. However, it will only work with the first sheet in your workbook, Unicode data won't come acress and only the first (can't remember how many) columns will come across. But can you describe what went wrong? Did you see any dialog boxes at all? Normally, Word tries OLE DB first, then if it fails, it tries ODBC and unfortunately there may be an error in the ODBC dialog box that prevents you from getting any further. Peter Jamieson "P.J." wrote in message ... Hi all, I had an existing 2003 spreadsheet and updated it to a 2007 excel spreadsheet. I am familiar with mail merge, but I cannot get the data to import properly. What am I doing wrong? I tried the Wizard and also tried the manual insertion. The word document was created in Word 2007. Thanks for any help you all might have. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word crashes when I try to mail merge using Outlook recipients | Mailmerge | |||
Mail Merge insert merge fields | Mailmerge | |||
Mail Merge | Mailmerge | |||
Heavy Mail Merge Application | Mailmerge | |||
How to get all mail merge fields in a document | Mailmerge |