Wrox Programmer Forums
|
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 4th, 2003, 05:21 AM
Registered User
 
Join Date: Aug 2003
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default Sending email attachments

Hello,

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?

Thanks,
Karen.

 
Old August 8th, 2003, 07:00 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 120
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Karen

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.
 
Old August 8th, 2003, 07:07 AM
Registered User
 
Join Date: Aug 2003
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default


Thanks very much!
It's much appreciated.
Karen.






Similar Threads
Thread Thread Starter Forum Replies Last Post
sending mails with attachments in smtp hermoine Pro JSP 1 May 1st, 2007 04:35 AM
Email with Attachments echovue Access 2 March 22nd, 2005 10:36 AM
sending email with attachments harpua Classic ASP Basics 2 February 16th, 2005 07:26 PM
Email attachments tucker Excel VBA 1 June 10th, 2004 03:25 AM
Email Attachments Doug Riede Classic ASP Basics 0 October 24th, 2003 11:11 AM





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