Mail merge zip codes

D

DJ

Hi
I can't get mail merge (in Word) to recognize a zip code that begins with a zero. The data column in Excel does recognize it, but the leading zero won't cross over, everything else works great!
 
L

Leslie

In the Word document, go to Tools, Options, General, and
click the option to Confirm Conversion on Open. Then
begin the Mail Merge. When you go to open the Excel file
as your data source you will be prompted to Confirm the
Data Source, choose the Microsoft Excel Worksheet via DDE
option. You should get your zip codes!
-----Original Message-----
Hi
I can't get mail merge (in Word) to recognize a zip code
Click to expand...
that begins with a zero. The data column in Excel does
recognize it, but the leading zero won't cross over,
everything else works great!
 
D

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT

See the following page from fellow MVP Graham Mayor's website

http://www.gmayor.com/formatting_word_fields.htm

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP
 
Top