Unable to Open Data Source

[TJ Burke]

I ssend an email merge document successfully using an excel data source, but
when I try to send the same doc to a different excel list, I get an "unable
to open data source" error message.
I have search many "tips" but only get fixes/workarounds for Access & Word
2002
Please help!!!! Trying to send very important email to new list
Many Thanks,
Teej

 

[Peter Jamieson]

As a workaround (and since it looks like you are in a hurry) I would export
the data you want to use from Excel, and/or copy/paste it into a Word table,
and use that as the data source.

Even if that doesn't work, it may help us to identify what is going wrong.

 

[TJ Burke]

Sorry for delayed response.....Had to send individually to get them out
Tried pasting into word table, but got an error message...."Word unable to
open because it didn't contain a valid database."
Teej

 

[Peter Jamieson]

...."Word unable to

open because it didn't contain a valid database."

When you pasted, did you end up with a table in Word or a delimited layout?

Sorry, I also forgot to say that you probably need to insert a row/line at
the top containing the column names.