Sending multiple tables using sendobject

[mazza]

My database requires remote users to send 4 tables by e-mail to 1 controller.
Using the sendobject method I can only send a table at the time, i.e. 4 different e-mails each with 1 attachment.

Is there a code to attach 4 tables to the 1 e-mail?

I am using access 2000/2 and outlook.

 

[jgc31]

Can you create a query which returns the contents of your 4 tables and send that?

 

[mazza]

not really, the data and structure are different and besides as they are send in xls format, they are being imported/appended again in the same tables in the controllers database for him to have a complete view of what is happening.

 

[RoyVidar]

Sendobject, as far as I know, don't handle multiple attachements. You'll probably need to autamate Outlook, here's one thread from a quick search
http://www.access-programmers.co.uk/forums/showthread.php?p=364050