If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|