If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"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
|
|||
|
|||
"0" appears in Mail Merge
Hi =?Utf-8?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 :-) |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
NO CODE - mail merge to Outlook with attachment with CC | GillianHG | Mailmerge | 3 | February 10th, 2010 02:53 PM |
How do I mail merge to EMAIL from MS Word AND add a pdf attachment | Lily@Insight | Mailmerge | 24 | January 15th, 2007 09:33 PM |
Every time I use Autotext the mail merge toolbar appears | mohare | General Discussions | 0 | February 1st, 2006 12:00 PM |
How to stop source prompt in mail merge from access | mvb | Mailmerge | 0 | September 6th, 2005 05:11 PM |
Mail Merge for Catalog document | Terry | General Discussion | 1 | July 27th, 2004 05:33 AM |