from access to outlook - more then one insert files

[יריב החביב]

Hello,

We use the sendbject code to send E-mail's with attached file's

from access to outlook.

Is it possible, and how to send in the same e-mail two attached files

that are not in the same format (snp,xls,txt.....) ?

thank you

 

[Arvin Meyer [MVP]]

Sure, the code is at:

http://www.datastrat.com/Code/OutlookEmail.txt

Notice that there are 2 attachments, one of which is commented out. Using
this code, you can add as many attachments as you like. The code uses early
binding, so you must set a reference to Outlook. That should be a problem,
since you are using it. You can also use late binding (GetObject) and not be
bothered with the reference.

 

[יריב החביב]

Thank you,

The document that i want to attached are report's from my access

application and not saved on the coputer disc

How do i call them ?

 

[Arvin Meyer [MVP]]

In order to use the code I mentioned, you will need to save them as a file,
either a snapshot, or a PDF, if you have that capability.

Steve Arbaugh has a class, which when combined with a PDF creator, you can
use to email multiple Access reports to one or more recipients:

http://www.groupacg.com/
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[יריב החביב]

THANK YOU VERY MUCH !!!

 

[suzuki]

THANK YOU VERY MUCH !!!