ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I fix loosing 1st digit in zip code in mail merge? (https://www.excelbanter.com/excel-worksheet-functions/111365-how-do-i-fix-loosing-1st-digit-zip-code-mail-merge.html)

Lori

How do I fix loosing 1st digit in zip code in mail merge?
 
I have a spreadsheet with headers for a mailing. When I do the mail merge
the first digit in the zip code is dropping off. I have the cells formated
for zip code and it is still doing the same thing. Working with Office 2003.

Debra Dalgleish

How do I fix loosing 1st digit in zip code in mail merge?
 
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


Lori wrote:
I have a spreadsheet with headers for a mailing. When I do the mail merge
the first digit in the zip code is dropping off. I have the cells formated
for zip code and it is still doing the same thing. Working with Office 2003.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html


ALEX

How do I fix loosing 1st digit in zip code in mail merge?
 
The answers in the article are only for Office 2003. How do you do it with
Office 2007?
Thanks

"Debra Dalgleish" wrote:

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


Lori wrote:
I have a spreadsheet with headers for a mailing. When I do the mail merge
the first digit in the zip code is dropping off. I have the cells formated
for zip code and it is still doing the same thing. Working with Office 2003.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html




All times are GMT +1. The time now is 05:05 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com