Mergefield Format - Numbers and Text
Thanks Doug.
This helped me fix the "0" issue I was having.
"Doug Robbins - Word MVP" wrote:
If using a version of Word before 2007, from the Tools menu, select Options
and then go to the General tab and check the box for "Confirm conversions at
open ". If using Word 2007, click on the Office button and then on Word
Options and then on Advanced and go to the General section of the dialog and
check the box for "Confirm file format conversion on open"
After doing that, when you attach the data source to the mail merge main
document, select the DDE option for the method by which the attachment
should be made (In Word 2007, it is necessary to click on the "Show all
formats" button to see that option.
--
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
"VickiMc" wrote in message
...
In my (Excel) Database I have Field I need to merge which contains a four
digit Code, the majority of which are numbers eg 6781. These merge fine
without any requirement to place a switch, however one or two of the codes
are made-up of four letters and are displayed as a single zero.
*MERGEFORMAT,
& *CHARFORMAT result in a blank field.
What do I have to stipulate to get the text to appear in the Mergefield?
PS I have formatted the column in Excel as TEXT.
|