Email individual invoices

5 pts.
Tags:
Email
Macros
I have macros in MS Access that email reports to groups of people. I am trying to work a way where I run a macro and it will send the specific report to each person. I have a list of 52 membership invoices that go out annually. Is there a way to get the query or macro to send the specific invoice to each person? Currently I have to create 52 seperate invoices and send out 52 emails.

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • CompleteITProfessional
    Yes, you should be able to write a macro for this. You can store the emails and other details in a table, load this in a macro, and create the emails. i don't know if it will let you send them, but it should at least prepare them for you. I also run a website that helps YOU to improve your IT career - http://www.CompleteITProfessional.com. Thanks!
    350 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: