Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Crystal B
 
Posts: n/a
Default preceeding zeros in postal codes of mail merge


how to print preceeding zeros in postal codes of mail merge from excel
list when that excel field is formated as zip code and excel prints
correctly.
example:
excel field zip code 01035
merge field zip code 1035
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
 
Posts: n/a
Default preceeding zeros in postal codes of mail merge

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

"Crystal B" Crystal wrote in message
...

how to print preceeding zeros in postal codes of mail merge from excel
list when that excel field is formated as zip code and excel prints
correctly.
example:
excel field zip code 01035
merge field zip code 1035



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Crystal B
 
Posts: n/a
Default preceeding zeros in postal codes of mail merge

Thanks!

"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

"Crystal B" Crystal wrote in message
...

how to print preceeding zeros in postal codes of mail merge from excel
list when that excel field is formated as zip code and excel prints
correctly.
example:
excel field zip code 01035
merge field zip code 1035




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
how to use postal codes on a mail merge Scott972 Mailmerge 1 July 19th 05 04:00 AM
mail merge shows blanks as zero's gareth Mailmerge 1 June 9th 05 08:23 PM
Mail Merge some international postal codes displayed as "0" cmcintyre Mailmerge 0 April 18th 05 11:35 PM
mail merge with attachments AS Mailmerge 5 April 9th 05 09:49 AM
Mail merge drops zip codes and replaces with zero Shana Mailmerge 1 March 7th 05 11:21 PM


All times are GMT +1. The time now is 01:21 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"