View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Yendorian Yendorian is offline
external usenet poster
 
Posts: 32
Default Excel Word Mail Merge

Hi Bernard,
Thanks for the prompt reply. I've looked through the links but cannot find
an answer to my query there.
I think I've got the actual creation of the mail-merge process correct -
I've done it several times before.
But i can't find an explanation as to why a few of my EXCEL column headings
do not appear in the 'Insert Merge Field' tab in my Word document. As I said,
I have 55 field headings called "A" through to "BC" but only the letters "A"
to "AT" appear on the 'Insert Merge Field' tab and the info contained under
mergefields "AU" to "BC" in the WORD doc appears as a 'Error! MergeField was
not found in header record of data source' message (which seems to be
logical).
Somewhere along the line, not all the columns of data are being transferred
from EXCEL to WORD.
Hope this makes it a little clearer.
Yendorian

"Bernard Liengme" wrote:

Have a look at these:
For help on Word mail merge using Excel as the data source have a look here

http://www.mvps.org/dmcritchie/excel/mailmerg.htm

http://www.mvps.org/word/FAQs/MailMe...AMailMerge.htm

http://www.mvps.org/word/FAQs/MailMe...ateADataSource.

50 min MS tutorial
http://office.microsoft.com:80/train...RC011205671033
Debra Dalgleish posted this: There's an article on the Microsoft web site
that might help you:
Answer Box: Numbers don't merge right in Word
http://office.microsoft.com/en-ca/as...164951033.aspx

And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill has
instructions he
http://sbarnhill.mvps.org/WordFAQs/C...ngWord2002.htm
about half way down the page.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Yendorian" wrote in message
...
Working with Office 2003, I am trying to merge data from an EXCEL file to
use
in a WORD doc. and getting an intermittent fault. In all, I have 55 column
headings in my EXCEL workbook but when I try to merge these into my WORD
doc
only 49 of them appear in the 'Insert Merge Field' tab and in the
document.
I have tried using simple letters instead of full words as column headings
(e.g. "A" through to "BC" instead of "Surname", "Address" etc.) and there
are
no hidden columns or spaces before the letters. On occasions I do get all
the
required merge fields but only after closing down and starting the
programme
again.
I azm merging using DDE as I want to preserve the formatting from the
EXCEL
file.
Can anyone help, please?
Yendorian