Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
In addresses the first 0 in the zip code does not show or print when merged
to Word labels. |
#2
![]() |
|||
|
|||
![]()
There's an article on the Microsoft web site that might help you:
Answer Box: Numbers don't merge right in Word http://office.microsoft.com/en-ca/as...164951033.aspx Bailey wrote: In addresses the first 0 in the zip code does not show or print when merged to Word labels. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
![]() |
|||
|
|||
![]()
Here are a couple of options.
1. Format all your zip codes in Excel as text. 2. In Word, before you start the merge: Tools | Options | General and Check the Confirm Conversion at Open Then, when you choose the Data Source for the Merge, a dialog should pop up. Choose worksheets via DDE. tj "Bailey" wrote: In addresses the first 0 in the zip code does not show or print when merged to Word labels. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
When printing labels by using Excel data in a Word mail merge, ho. | Excel Discussion (Misc queries) | |||
Extract Data for Mail Merge | Excel Discussion (Misc queries) | |||
Can you print labels using Excel 2002 in a Word 2002 mail merge? | Excel Discussion (Misc queries) | |||
Word field codes in Excel data file Includetext | Excel Discussion (Misc queries) | |||
Can I mail merge filtered data on an Excel spreadsheet to a word d | Excel Worksheet Functions |