Email Macro Question

[Kevin Field]

Is it possible for me to have a table of email addresses and then have a macro use that list to simply fire out emails to all of the listed emails?

I currently have a macro for each email address. As you can imagine, its not helpful.

 

[Mr. B]

Take a look at the link below. It will show you how to create a loop in your macro so you can loop through all of the email addresses.

http://support.microsoft.com/kb/209790

 

[Kevin Field]

Sorry Doctor B, a little confused. Will this still be able to pick up and use email addresses stored in a database table? Or will it still require me to make a macro for each of the email addresses?

In essence, i want to have a form which allows you to select an individual, press go and then outlook automatically prefills with that persons address and sends the email with a snapshot of a report.

 

[Mr. B]

Kevin,

I provided the link to show you how you could use a macro and do a loop that would process the conditions in a macro multiple times.

As for doing what you really want to do, it is very possible to have a form and be able to make the necessary selection(s) of criteria and then have Access to create content in an email, including adding an attachment, and then send the email to an entire list of a filtered list of reciepients.

Personally, I would use VBA code to accomplish this. You indicated that you "have a macro for each email address. In my opinion, it would be more efficient to have one routine or even one function that would handle the whole thing.

With that said, do you have any experience with VBA? If not, then you may be able to create a macro that would run each of your macros that sends one email. Just a thought.