> So is it possible to have 2 different data
> sources in 1 mail merge document?
No, there can only be one "Data Source".
It may be possible to work around this but it depends on what you want to do
and what data you have in your spreadsheets. If, for example, the columns in
your two sheets are the same and you just want to treat the data as if the
second sheet's data followed the first, then
a. the simplest approach is just to combine the contents of the two sheets
into a new Excel sheet, and use that as the data source. You could do that
manually or probably using some Excel VBA.
b. it is possible to use Word VBA'sOpenDataSource method, the ODBC
connection method, and an SQL UNION query to get the data from both sheets.
Personally, I'd avoid attempting that unless I really had to.

Signature
Peter Jamieson
> Hi! I wanted to ask if it is possible to have 2 different
> tables where I get my data in the same document!I use mail
[quoted text clipped - 4 lines]
>
> Thanks in advance
gioulil - 01 Sep 2004 12:18 GMT
Thanks a lot!
I think the best solution is one new spraedsheet!!!
Thanks again
>-----Original Message-----
>> So is it possible to have 2 different data
[quoted text clipped - 22 lines]
>
>.