E-Mailing a Table

[jboyle]

I have a database that is updated on a daily basis. There is a particular table within the database that I need to E-Mail to my customer every day. I want to know if there is a way in Access to send the particular table attached to an E-mail instead of going into Lotus Notes and manually attaching the table to send.
I thank you in advance for your help - John

 

[Val]

I had to do something very similar and talismanic was good enough to point me in this direction. Hope it works for you to.

This will send the table as a text file.

Docmd.SendObject actable, "Table Name", "Ms-DOSText(*.txt)", "E-mail Address",,,,False

 

[jboyle]

Thanks for the tip Val but I need the table to be sent as an Access table not text. The customer uses this table as part of their application.
Thanks - John

 

[PearlGI]

As far as I am aware, if you want to detach a table from a database to send to someone else, then you have to export using a format such as text, excel, dbf etc.
Then to avoid leaving it to the user to import the table, you would then need to set up an import routine on the receiving database, either to overwrite or append to an existing table. And since text would create the smallest file size, surely this would be the prefered approach.

 

[Atomic Shrimp]

I think john is right; the only way to copy/move a table from one database to another without exporting it to some intermediate format is if the databases exist on a network where they can see each other, then you could just import or link.