By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,222 Members | 1,129 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,222 IT Pros & Developers. It's quick & easy.

Email from within Access - Multiple Attachments

P: 2
Many thanks to PuppyDogBuddy or the reference to code samples to send an email and an attachment from within Access, all up and running.
However I'm having trouble adding multiple attachments. Does anyone have an answer

Thanks

Drews
Dec 30 '07 #1
Share this Question
Share on Google+
1 Reply


nico5038
Expert 2.5K+
P: 3,072
Check:
http://www.mvps.org/access/general/gen0032.htm

The second code sample holds:
Expand|Select|Wrap|Line Numbers
  1. With olMail
  2.     .To = "Graeme.Wilson@nationsbank.co.uk"
  3.     .Subject = "Graph Info " & Format(Now(), "dd mmm yyyy  hh:mm")
  4.     .Attachments.Add strFileName
  5.     .ReadReceiptRequested = False
  6.     .Send
  7. End With
  8.  
The ".Attachments.Add strFileName" can be used multiple times for multiple attachments.

Nic;o)
Dec 30 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.