[Clete]

Im trying to do a mail merge in Word. The mail database is in Excel.

The ZIP codes are correct in Excel, but when merged into the Word document,
ZIP codes are not correct.

€¢ when they have a leading zero, 08055 becomes 8055
€¢ for Canadian addresses, the ZIP code always becomes 0. It should be
N6L-1A4, for example.

The ZIP codes are formatted as Special, ZIP code in Excel.

[Doug Robbins - Word MVP]

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

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


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

"Clete" wrote in message
...
I'm trying to do a mail merge in Word. The mail database is in Excel.

The ZIP codes are correct in Excel, but when merged into the Word
document,
ZIP codes are not correct.

. when they have a leading zero, 08055 becomes 8055
. for Canadian addresses, the ZIP code always becomes 0. It should be
N6L-1A4, for example.

The ZIP codes are formatted as Special, ZIP code in Excel.

[Clete]

Doug,

Thanks. This solved the problem for me.

Clete

"Doug Robbins - Word MVP" wrote:

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

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


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

"Clete" wrote in message
...
I'm trying to do a mail merge in Word. The mail database is in Excel.

The ZIP codes are correct in Excel, but when merged into the Word
document,
ZIP codes are not correct.

. when they have a leading zero, 08055 becomes 8055
. for Canadian addresses, the ZIP code always becomes 0. It should be
N6L-1A4, for example.

The ZIP codes are formatted as Special, ZIP code in Excel.