Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Like the morning Like the morning is offline
external usenet poster
 
Posts: 2
Default Mail Merge addresses with zipcodes that begins with a zero

When I need to mail merge addresses that have zipcodes that begin with 0 - as
in 06790 - it drops the "0". I have formatted the zipcode column in excel to
be a zipcode and it shows the 0 in excel.
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Mail Merge addresses with zipcodes that begins with a zero

See the discussion on that issue in "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

"Like the morning" wrote in
message ...
When I need to mail merge addresses that have zipcodes that begin with 0 -
as
in 06790 - it drops the "0". I have formatted the zipcode column in excel
to
be a zipcode and it shows the 0 in excel.



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Like the morning Like the morning is offline
external usenet poster
 
Posts: 2
Default Mail Merge addresses with zipcodes that begins with a zero

I have Word 2007, I can't follow what the article explains.

"Doug Robbins - Word MVP" wrote:

See the discussion on that issue in "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

"Like the morning" wrote in
message ...
When I need to mail merge addresses that have zipcodes that begin with 0 -
as
in 06790 - it drops the "0". I have formatted the zipcode column in excel
to
be a zipcode and it shows the 0 in excel.




  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Mail Merge addresses with zipcodes that begins with a zero

The version of Word makes no difference. All the information that you need
is in the US Zip Codes section of the web page.

Try again in the evening.

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

"Like the morning" wrote in
message ...
I have Word 2007, I can't follow what the article explains.

"Doug Robbins - Word MVP" wrote:

See the discussion on that issue in "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

"Like the morning" wrote in
message ...
When I need to mail merge addresses that have zipcodes that begin with
0 -
as
in 06790 - it drops the "0". I have formatted the zipcode column in
excel
to
be a zipcode and it shows the 0 in excel.






Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
addresses don't show up after mail merge blc Mailmerge 1 November 28th 07 02:21 PM
Mail Merge and zipcodes.. shawn Mailmerge 1 April 13th 07 03:37 PM
e-mail addresses for Word mail merge have format error cjfi Mailmerge 1 June 5th 06 04:54 PM
zipcodes that begin with zeros or foreign codes in a mail merge H Meliss Mailmerge 1 December 6th 05 04:55 AM
How do I mail merge addresses on to 2-up postcards Don Mailmerge 1 August 27th 05 06:01 AM


All times are GMT +1. The time now is 06:46 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"