mail merge from 2 separeted tables?

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
merge all the time and I get my data always from 1 table
(usually Excel), but this time I want to use 2 different
ecxel sheets?? So is it possible to have 2 different data
sources in 1 mail merge document??

Thanks in advance

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.
--
Peter Jamieson

"gioulil" wrote in message
...
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
merge all the time and I get my data always from 1 table
(usually Excel), but this time I want to use 2 different
ecxel sheets?? So is it possible to have 2 different data
sources in 1 mail merge document??

Thanks in advance

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
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.
--
Peter Jamieson

"gioulil" wrote in message
...
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
merge all the time and I get my data always from 1 table
(usually Excel), but this time I want to use 2 different
ecxel sheets?? So is it possible to have 2 different
data
sources in 1 mail merge document??

Thanks in advance


.