Zip codes in mail merge

Re: Field codes use in mail merge. You can use anything from '0' to '0. Note that this suppresses 0s resulting from empty fields and from fields containing 0s. Note2 : If you use a decimal tab or right-aligned tab to align the values, wrap the switch in quotes i.

Select your mergefield. For the purposes of this example, I'll suppose it's named 'Value' and shows up as '«Value»' in your mailmerge main document.

Run your mailmerge. Basic Mailmerge Maths You can create the formula in Word to perform maths on a mergefield. Note : the precision of the displayed value is controlled by the '0. Applying a date format switch fixes that - and gives the mailmerge document the ability to format the date independently of whatever format is used in the data source. With this switch your dates will come out like '2 August '. Viewed 2k times.

Improve this question. Add a comment. Active Oldest Votes. Improve this answer. Georges Brisset Georges Brisset 2 2 silver badges 6 6 bronze badges. In the general case, this isn't enough to solve the problem, unless the user is connecting to Excel using DDE.

Text values in the column will come through to Word as 0. So ' will be treated as 0. So not so "simply"! Laura Haglund Laura Haglund 1. Sign up or log in Sign up using Google. Sign up using Facebook. Note: the DDE option will only import the primary first worksheet of your excel so make sure your mail list is in the first excel tab.

Another answer that worked for me is to format your Zip Code column in Excel to "Text" instead of numbers. If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.

Please note: Do not post advertisements, offensive material, profanity, or personal attacks. Please remember to be considerate of other members. All submitted content is subject to our Terms Of Use. General discussion. She wants to use this data list to print mailing labels. Neither of us are expert Excel users and I have been unable to find an answer to this. Any help would be greatly appreciated!!

Thank you. Share Flag. All Comments.