mail merge from 2 separeted tables?

[gioulil]

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

 

[Peter Jamieson]

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.

 

[gioulil]

Thanks a lot!

I think the best solution is one new spraedsheet!!!
Thanks again