Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / December 2003

Tip: Looking for answers? Try searching our database.

Candian Zip code (letters) are delete in mail merge

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
- 11 Dec 2003 00:59 GMT
The mail merge system is completely deleting the
international zip codes.
Peter Jamieson - 11 Dec 2003 08:47 GMT
A similar question came up a cople of days ago...

A few questions:
a. Which version of Word?
b. What is the data source?
c. If the data source is Excel, does the Excel column containing the codes
have a mixture of code types
(e.g. numeric US codes, alphanumeric Canadian codes, other?). If so, are the
first few codes in the column all numeric? Or is the column formatted as
numeric?

If the column is formatted as numeric or the first few codes are all-numeric
codes, Word may treat the entire column as numeric.If that is the problem
you
may be able to fix it by changing the column format (make a copy of your
spreadsheet first!) so that it is text, or changing the way Word connects to
Excel (I'd try checking Word Tools|Options|General|"confirm conversions at
open", going through the connection process again, and selecting the DDE
option when it is offered). If you change the column format, you will
probably still need to rconnect to the data to get Word to "see" the change.

--
Peter Jamieson - Word MVP
> The mail merge system is completely deleting the
> international zip codes.

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.