Email Multiple People with Personal Attachment - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Email Multiple People with Personal Attachment

Tom Juric

15 months ago

I am looking for ideas on how to send multiple emails each with its own attachment.

I have a database that has a field called IsPaid and also creates an Invoice once service is completed. At the end of the day, I want to send each customer who had service that day an email with his/her own invoice for the services rendered (most services differ by customer). Currently my client is using MS Outlook for his emails and manually sends the emails out. Maybe in the future I can make this happen for a client who does not have Outlook

I have done some really neat stuff in Access but this has me stumped!! ANY help is greatly appreciated!

Donald Blackwell @Reply

15 months ago

https://599cd.com/blog/display-article.asp?ID=1703 This is Richard's Tech Help video for sending invoices with Outlook from access however, if your client is using Classic Outlook (desktop) it should work, but currently, if he upgrades to new Outlook or Web, it may (probably won't) not.

Another techhelp https://599cd.com/blog/display-article.asp?ID=3325 shows how to do it using other mail options

	Juan Rivera @Reply 15 months ago
it works I use it the key is to place a timer pause very small about 1 sec, and do one email at a time as it loops throw in there a do events as outlooks sometimes opens is holding for you to send the email. this way the do events will continue to prep the next email but it works i send out letters to individuals with the names on them attachemtns included with no issues.

	Tom Juric OP @Reply 15 months ago
I get error "Object doesn't support this property or method" When I use this line of code-- SendOK = SendEmail(Email, "[email protected]", Subject, Body, Nz(EmailReplyTo, ""), Nz(EmailCC, ""), Nz(EmailBCC, ""), True, Nz(Attachment, "")) Debug-->Compile had no errors I cant see the issue

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View