send mail with attach in .xls and .snp

[geert.van.ransbeeck]

Hello

I have generated a fully formatted excel sheet from code in access,
which is saved on my hard drive.
I have allready a procedure which sends the same data in snapshot
format by mail to my contacts.

DoCmd.SendObject acReport, "RPT_RADI1", "SnapshotFormat(*.snp)",
"VBRAR", "VHERO", "", pbsuject3 & " - RADI tot EVVD", strcontents,
True

How can I add the the excel-sheet as a second attachment in the same
mail?

 

[Alex Dybenko]

Hi,
you can first save your report to a temp file as snapshot, and then send
both files creating outlook message like here:
http://www.mvps.org/access/modules/mdl0019.htm

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[geert.van.ransbeeck]

I 've set Set a reference under Tools/References to Microsoft CDO 1.21

'Sub TestMAPIEmail()
Dim clMAPI As clsMAPI

I've got: compile error: user defined type not defined.

any help?

 

[Alex Dybenko]

Hi,
do you have clsMAPI class module imported into your mdb?

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com