p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Access VBA (http://p2p.wrox.com/forumdisplay.php?f=80)
-   -   Sending email attachments (http://p2p.wrox.com/showthread.php?t=2396)

KARENM August 4th, 2003 05:21 AM

Sending email attachments

Another question. I know how to send a report within Access as an email attachment. What I would like to know is, is there a way of attaching more than one report to an attachment (same format) in VB?


Braxis August 8th, 2003 07:00 AM


It can be done, but it'll make your life much more complicated!

Assuming you're using Outlook as the email client, you'll need to have a look at the Outlook object model and Dmitry Streblechenko's Redemption (http://www.dimastr.com/redemption/) stuff to bypass Outlook's security features.

This article (http://www.mvps.org/access/general/gen0032.htm) should give you an idea of the code you'll need.

If you're email client isn't Outlook, then it gets even harder...

Brian Skelton
Braxis Computer Services Ltd.

KARENM August 8th, 2003 07:07 AM

Thanks very much!
It's much appreciated.

All times are GMT -4. The time now is 01:22 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.