Mail merge zip codes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DJ - 23 Jan 2004 18:51 GMT

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!

Reply to this Message

Leslie - 23 Jan 2004 21:16 GMT

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 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!

Reply to this Message

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 24 Jan 2004 00:49 GMT

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

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

Signature

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

> 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!

Reply to this Message