Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
JT
 
Posts: n/a
Default "0" appears in Mail Merge

I am doing what I think is a simple merge of data from an Excel sheet into
mailing labels in Word. However my "address" column in Excel (which contains
address data) merges into the Word labels with only a "0" where the address
should be.

I can't seem to get the address data over. Any help is very much appreciated.

JT
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Cindy M -WordMVP-
 
Posts: n/a
Default "0" appears in Mail Merge

Hi ?B?SlQ=?=,

I am doing what I think is a simple merge of data from an Excel sheet into
mailing labels in Word. However my "address" column in Excel (which contains
address data) merges into the Word labels with only a "0" where the address
should be.

It always helps to tell us which version of Word (or Office) is involved?

In this case, please also copy the contents of a couple of these cells into your
reply so we can see what kind of data it contains.

Best guess: the majority of the first eight or so records have numeric content,
only, in this column. So Excel is marking it as numeric and passing a 0 for all
records that contain text.

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
How to get all mail merge fields in a document [email protected] Mailmerge 3 February 17th 06 05:43 AM
Mail Merge date appears in French Mike Abel Mailmerge 2 January 27th 06 08:07 AM
Mail Merge Losing Data Scott May Mailmerge 1 November 1st 05 11:03 PM
mail merge with attachments AS Mailmerge 5 April 9th 05 09:49 AM
Mail Merge Issue With Office 97 - Excel Data Source Matt Thorley Mailmerge 1 February 15th 05 11:38 PM


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

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

About Us

"It's about Microsoft Word"