Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Word 2007
I am trying to do a mail merge pulling data from Excel into fields in a Word
table. Excel fields with a larger amount of data are being cutoff during the merge. The fix in 2003 was to use a DDE connection but when I attempt this in 2007 i get an error that a DDE connection could not be established. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Word 2007
I have also found DDE connections to Excel to be less reliable in 2007 (on
Vista, here). As long as you have fewer than 64 columns in your sheet, I suspect your best bet will be to select your data in Excel, Copy, then Paste it into a new Word document, save that and use it as a data source. Otherwise, do all the columns that contain cells with more than 255 characters of text have a cell with more than 255 characters in the first 8 rows? If not, can you experiment, i.e. copy your spreadsheet, modify the data so that that is the case, and try reconnecting using OLE DB? (I cannot be certain that this will work, and their are also other pitfalls when using the default connection technique, as per http://tips.pjmsn.me.uk/t0003.htm. But it seems worth trying). -- Peter Jamieson http://tips.pjmsn.me.uk "Roxene" wrote in message ... I am trying to do a mail merge pulling data from Excel into fields in a Word table. Excel fields with a larger amount of data are being cutoff during the merge. The fix in 2003 was to use a DDE connection but when I attempt this in 2007 i get an error that a DDE connection could not be established. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mergeing excel 2007 data with a label created in word 2007 | Microsoft Word Help | |||
insert Access 2007 database table into a Word 2007 doc and print | Microsoft Word Help | |||
Unable to download templates using Word 2007 (MS Office 2007 Stand | Microsoft Word Help | |||
multi-page visio 2007 in word 2007 with automatic figure caption | Microsoft Word Help | |||
Change layout of address inserted from Outlook 2007 to Word 2007? | Microsoft Word Help |