Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
jboeg632
 
Posts: n/a
Default Why am I getting 0 instead of data in a mail merge?

I am trying to create a mail merge from an Excel file, and the only problem
that I am having is that in the "zip code" column when put into the mail
merge only comes up as 0's. Why is that? How do I fix it?
Thanks
  #2   Report Post  
Posted to microsoft.public.word.docmanagement
Cindy M -WordMVP-
 
Posts: n/a
Default Why am I getting 0 instead of data in a mail merge?

Hi ?B?amJvZWc2MzI=?=,

I am trying to create a mail merge from an Excel file, and the only problem
that I am having is that in the "zip code" column when put into the mail
merge only comes up as 0's.

Without knowing the version of Word, it's not easy to give a definitive
answer. Probably, you're using Word 2002 or 2003 and the information in the
Zip column is mixed numeric and non-numeric? In that case, select the entire
column, go to the Data menu and use the Text to Columns tool. Set the column
specifically to be "TEXT" (not general or numeric). SAVE the change, link the
data back into the mail merge document, and test.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)

Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge Losing Data Scott May Mailmerge 1 November 1st 05 11:03 PM
DotNet Data Table as Mail Merge Data Source goraya Mailmerge 1 July 7th 05 09:51 AM
Specific Email Merge w/ Specific Attachements Mark B Mailmerge 9 February 21st 05 05:10 AM
Mail Merge Issue With Office 97 - Excel Data Source Matt Thorley Mailmerge 1 February 15th 05 11:38 PM
Mail merge data source problem campwes Mailmerge 1 January 25th 05 07:16 PM


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

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"