Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
0 value in mailmerge field
Have letters to send out but some addresses include unit number / letter
combinations that appear as zeroes in merged docs - tried various "solutions" and some partially work, but have letter named units, number / letter combinations, and letter / number combinations. How to make mergefields pull what's in the dbase (excel 2003) cell into the merge doc? Thx / POM |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
0 value in mailmerge field
In Word, from the Tools menu, select Options and then the General tab and
check the box against the "Confirm conversion at Open" item. After doing that, when you attach the data source to the mail merge main document, select the DDE option in the dialog box that will appear. If that does not correct the problem, you may to to explicity convert the data in the field in Excel to Text. -- 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 "PoetsOnMars" wrote in message ... Have letters to send out but some addresses include unit number / letter combinations that appear as zeroes in merged docs - tried various "solutions" and some partially work, but have letter named units, number / letter combinations, and letter / number combinations. How to make mergefields pull what's in the dbase (excel 2003) cell into the merge doc? Thx / POM |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MailMerge Through VBA Printing Actual Field Names NOT Field Values | Mailmerge | |||
Help on Mailmerge field (field length) - field getting truncated | Mailmerge | |||
Help on Mailmerge field | Mailmerge | |||
TOC field and mailmerge | Mailmerge | |||
dateofbirth to age in mailmerge field | Mailmerge |