Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
TheAncientOne TheAncientOne is offline
external usenet poster
 
Posts: 1
Default Word Mail Merge from Excel

I have a database in Mail Merge that is not the same as in Excel. In Excel
the field is Text formatted and is from one to six numbers (ie 212 or 212,214
or 212, 214,...).
In the reference list the single number displays correctly and it merges
correctly. If it is supposed to be multiple numbers, the reference list
displays 0 and it merges as 0.
Any help would be warmly accepted.
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Word Mail Merge from Excel

Can you be a bit more precise about what you have in Excel?

Is it a column of data such as

214
212,214
212,214

with no space after the comma

Also, what do you mean by the "reference list"

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

"TheAncientOne" wrote in message
...
I have a database in Mail Merge that is not the same as in Excel. In Excel
the field is Text formatted and is from one to six numbers (ie 212 or
212,214
or 212, 214,...).
In the reference list the single number displays correctly and it merges
correctly. If it is supposed to be multiple numbers, the reference list
displays 0 and it merges as 0.
Any help would be warmly accepted.


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 in Word, from Excel, the merge results for a percentag. Conrad Klein Microsoft Word Help 1 November 11th 09 11:00 PM
MS Word Mail Merge from Excel -- Force Excel to open the datafile? [email protected] Mailmerge 6 September 26th 08 03:08 PM
How to merge Excel chart for mass Word Mail Merge for employees hmboomer Mailmerge 3 June 9th 06 10:08 PM
ExcelWord Mail merge transfers 16 digits when Excel shows only 3 John Richmond, Watford UK Mailmerge 8 April 26th 06 06:00 AM
Insert Merge Field problem with Word-Mail Merge from Excel documen Augusta E. Microsoft Word Help 2 June 20th 05 10:59 AM


All times are GMT +1. The time now is 09:50 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"