A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

leading zeros in mail merge



 
 
Thread Tools Display Modes
  #11  
Old May 10th, 2010, 01:56 PM posted to microsoft.public.word.mailmerge.fields
DP
external usenet poster
 
Posts: 223
Default leading zeros in mail merge

Thanks

"Doug Robbins - Word MVP" wrote:

If you use Alt+F9 after inserting the merge field, the display of field
codes will be toggle on to reveal { MERGEFIELD "fieldname" } and then you
can add the formatting switch inside the closing }

--
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, originally posted via msnews.microsoft.com

"dp" wrote in message
...
Peter - found the zip info in gmayor link and looks sooo simple but I
managed
to unsimplify it. I used the insert merge field button for the zip and
tried
to edit that, then I was adding spaces where none were needed. Took
Macropods
advise about Ctrl+f9 but this was adding another set of brackets. I
either
got nothing or an invalid merge field message.

Finally I typed the info {MERGEFIELD ZIP\#"00000"} and used the Ctrl+f9
and
it worked! Thank you both



"dp" wrote:

Peter - I printed your answer
and Macropod - I've printed out the link you sent.
Thanks for the information we have to try these.

"macropod" wrote:

Hi dp,

The following field code correctly formats 5-digit and 5+4-digit Zip
Code data, even where the source data may have incorrect
formatting such as a hyphen followed by trailing 0s after plain 5-digit
Zip Codes (eg because a db only accepts Zip Codes in the
5+4-digit format) or is formatted as a 5-digit or 9-digit string
without hyphens. A data field named ‘ZipCode’ is assumed.
{QUOTE
{SET Zip {MERGEFIELD ZipCode}}
{IF{Zip} 99999 {SET Zip {Zip \# "00000'-'0000"}}}
"{=-{=-{Zip}-Zip}/2 \# 00000;;}{=-({Zip}*(-1)-Zip)/2 \# ;-0000;}"}

Note: The field brace pairs (ie '{ }') for the above example are
created via Ctrl-F9 - you can't simply type them or copy & paste
them from this message.

--
Cheers
macropod
[Microsoft MVP - Word]


"dp" wrote in message
...
Using 2007 Excel and 2007 Word
A co-worker has a name/addr file in Excel and formatted the zip
column as
category, special 00000. Zip shows fine.

However when uses word mail merge to produce mailing labels, the
leading
zeros are dropped.

What need to be done?

TIA

.

.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:34 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.