Printing with MailMerge Wizard

[AlFAMale]

I am running OfficeXPSP3 on WindowsXPSP2.

I have an address list I created in Micsoft Excel, which I use as my data
source for printing mailing labels in Office.

I have some addresses that are in states whose Zip Codes begin with a '0'.

Even though they show up when I complete the merge in Office, the leading
zeroes do not print on the labels. I do have the column of Zip Codes on my
Excel spreadsheet coded as Zip Codes in the Special category of Numbers in
the Format Cells option.

I would appreciate any help or suggestions you can provide. Thank You.

 

[Beth Melton]

This is due to using a OLE DB data connection which reads the data in the
file rather than how it is viewed in Excel. IOW, all Word knows is it is
working with a number. The number format used in Excel is a property of the
cell which is not passed to Word.

There are two ways to work around this:
- Use a DDE connection instead
- Use a numeric format switch for the merge field to format it


DDE:
- In Word under Tools/Options/General turn on "Confirm conversions at open"
- Select the Excel data source again and when prompted select the DDE method


Numeric Format switch:
- Press Alt + F9 to toggle on the field codes
- At the end of the merge field add something like: \# "00000"
- Press Alt + F9 to toggle off the field codes
- Right-click the field and select Update field if necessary

For more on using a Numeric Format switch take a look at this Help page:
http://office.microsoft.com/client/...t=2&ns=WINWORD&lcid=1033&pid=CH100992711033#7

Please post all follow-up questions to the newsgroup. Requests for
assistance by email cannot be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Coauthor of Word 2007 Inside Out:
http://www.microsoft.com/MSPress/books/9801.aspx#AboutTheBook

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/