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

Group e-mail from Access database??

P: n/a
I have an Access Database of about 400 records, most records have a
character field with an e-mail address for the person in that record.
How can I use these addresses to create a group mailing to all these
people via Outlook Express, or Outlook 2002??

Tom
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Tom,

If you searched the group first you wouldn't need to post this! There
are a number of long threads which have links to other websites
(MVP's) which will cover this post.

David
Nov 12 '05 #2

P: n/a
to******@yahoo.com (TomSoCal) wrote:
I have an Access Database of about 400 records, most records have a
character field with an e-mail address for the person in that record.
How can I use these addresses to create a group mailing to all these
people via Outlook Express, or Outlook 2002??


You will need to use VBA code to run through a recordset either:
1) concatenating the email addresses to a string along with a comma,
sem-colon or other appropriate separater and then send one email with
all the bcc addresses;
2) individually send the emails.

Your method of sending emails may have some restrictions as to the
number of email addresses in the bcc field or the length of data in
that field.

For sample recordset logic see the Access Email FAQ at my website.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.