View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default Excel Word Mail Merge

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