Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / September 2004

Tip: Looking for answers? Try searching our database.

mail merge from 2 separeted tables?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
gioulil - 31 Aug 2004 09:30 GMT
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 - 31 Aug 2004 14:56 GMT
> 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]
>
>.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.