View Single Post
  #4   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 I am having problems doing a mail merge between word & excel

Once again, I was not the one with the problem so please do not respond to
my threads.

--
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

"challa prabhu" wrote in message
...
Mr. Doug Robbins is absolutely right.

Note; If you get the field names and data correct, then you can "Define'
your data as "print area" as well as "Define a Name" for your print area.
Either way you will be able associate it to the document for merging.

In your case the data structure is wrong. I tried it and it works.

Challa Prabhu

"Doug Robbins - Word MVP" wrote:

To be used as a mailmerge data source, I am (99.999%) sure that the first
row in the spreadsheet must contain the field names and that the data
must
commence immediately in the next row. It sounds like your data may be
otherwise arranged.

See the article "Creating a Mail Merge Data Source" at:

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


--
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

"Vanessa" wrote in message
...
When I attempt to do a mail merge from excel to word I get as far as
select
recipients, I pick the print area of the spreadsheet I'm working with.
It
gives me table which is blank and it changes the file name I am working
with.
What am I doing wrong