Sending E-mail to Multiple Addresses

[Kat]

Hiya,

I am trying to create a Contact Database in Access. This database includes
an e-mail field.

What I would like to be able to do is to run a query on specific customers
(say, all the customer from a specific City), and then be able to somehow
create an Outlook e-mail containing all of those customer's e-mail addresses.

So, for example, if I run a query for Atlanta, I want to be able to click on
a button or run something so that a new Outlook message pops up, and all 15
of those e-mail addresses populate in the "To" field.

I've searched online, including this forum, and found similar issues, but
they're usually specific to each person's cause, or they include code that I
either don't know how to use, or that I get errors on. I need, if possible,
some steps that would allow me to create a Macro or a Module that will help
me.

Now, if that's too complicated, I'd be willing to settle for a way to
concatenate all of those people's e-mails so I can copy and paste the list
(separated by semi-colons)... If that's an easier thing to do, I'll
settle... I know I could run the query and copy and paste e-mail addresses,
but if a group is too large, that will become too much of an issue... At
least with the grouping together, I can cut and paste one field....

Any help would be greatly appreciated.

Thank you,

 

[chris.nebinger]

Kat:

Here is a link which shows you how to do just what you want:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dno2k3ta/html/odc_ac_olauto.asp


Just a thought: Are you sure you want all 15 people to be able to see
each other's email address? Consider using the BCC field instead.


Chris Nebinger

 

[Kat]

Thank you for your response. It looks like the code in the example has you
manually putting the customer's names in. I need to be able to run different
queries or add a customer to a city and have it be added the next time I try
to send a mass e-mail. That's why I was thinking the concatenate thing might
be better....

Is there a way to make Access look in the e-mail field and take what's
there, from a Query?

Or string the text together w/semi-colons?

Thanks!

 

[freakazeud]

Hi,
what you can do is create a recordset and loop through it. While doing so
you create a long string which holds all the email addresses of the email
field.
A good example of this exact scenario can be found in my reply here:

http://www.utteraccess.com/forums/showthreaded.php?Cat=&Number=1107000&page=&view=&sb=5&o=&vc=1

HTH
Good luck

 

[Kat]

Thank you, HTH....

I have a question for you, though, w/regards to your post...

Is it only possible to do this through Form View? If so, can I make several
buttons on the Form to create e-mails that will take from specific records?
For example, if I have check boxes on my form that say: Atlanta, New York,
Miami.... can I put a button for each city that, when pushed, will then run a
query on all of the people w/Atlanta checked, and then create the e-mail (or
put the e-mail addresses together)?

Otherwise, I have to run a query on that city to bring up a table with all
the clients from Atlanta.... and I can't put a button on a query... although
I know you can put a button on the form to run a query, I'm not sure how that
works with what I'm trying to do...

Also, in the code, I get hung up on this line:

rs.Open "YourEmailTable", CurrentProject.Connection, adOpenDynamic,
adLockOptimistic

I tried to put the name of my table in that field ("YourEmailTable"), but it
still says "Compile Error: Invalid outside procedure"

Thanks!!

 

[freakazeud]

Hi,
I'm not exactly sure how your table structure looks, but normally this would
be done with a query.
You can reference the form controls where the user makes the criteria
parameter choice within the query fields criteria area e.g.:

[Forms]![YourForm]![YourControl]

If you run the query it should show you all the data you want.
Then you can use this query as a base of the automation code I linked you to
earlier, which could be executed from within the same form.
HTH
Good luck