[Rebecca]

Hi,

I'm having a problem when merging word documents with an excel data source.

Basically what's happening is:
With my excel document set up: with headings along the first row and mailing
details etc in the rest of the rows. I set the print area, save and close
it.
I then open my merge letter (word document) I follow the steps to link the
excel document to the word document using the mail merge toolbar. After
selecting the data file the MS Word then asks me which table I'd like to use?
I select the print area version of the document I want but instead of going
back to the word document so I can insert my merge fields, it gives me a
second table with nothing in the list and a workbook address of where the
data source is saved. It gives me options of clicking Ok or cancel; if I
click Ok a dialogue then pops up saying word was unable to open the data
source.

It only seems to be intermittant so I'm really not sure of why it happens
with some data fields and not with others. If someone knows the answer I'd
really appreaciate hearing from you.

Rebecca