Email more than one table

  • Thread starter Thread starter Marie B
  • Start date Start date
M

Marie B

Hi,

I have an Access 2003 database, and would like to set up a command button on
a form that will email 3 tables to a specific address.

At the moment I have a macro (I know this is something of a dirty word, but
due to my lack of vba knowledge was the only way I could think of!) that uses
the SendObject action, but I can only get it to send 1 table in each email.

Is there an easy way to add tables 2 and 3 to the email attachments?

All help very gratefully received.

Many thanks,

Marie
 
Hi,

I have an Access 2003 database, and would like to set up a command buttonon
a form that will email 3 tables to a specific address.

At the moment I have a macro (I know this is something of a dirty word, but
due to my lack of vba knowledge was the only way I could think of!) that uses
the SendObject action, but I can only get it to send 1 table in each email.

Is there an easy way to add tables 2 and 3 to the email attachments?

All help very gratefully received.

Many thanks,

Marie
Click to expand...

simple answer, automate Outlook. SendObject is severely limited in
what it can do. The only other way to do it would be to write a weird
union query where you put blank lines between the result sets. Would
be easier and neater just to go the automation route.
 
I would hazard the guess that the most common approach is to export the
tables to excel sheets; and then attach those to an email.

If the recipient has Access; you could just import those 3 tables into a new
standalone Access mdb file...and email that to them as an attachment....
 
Hi Piet,

Appreciate your reply, would never have guessed to do it through Outlook.

Thanks,

Marie
 
Thanks for replying - a good idea, but due to an overzealous IT dept
receiving Access files through email is a problem!

Will remember it for future reference - much appreciated.

Marie
 
If you rename the MDB file so that it has a different file extension and zip
it, it should get through the mail filters.

Send your users instructions for how to unzip and rename the file.
 
Back
Top