Email Mailshot

[laura]

I am not sure if this is the right forum to ask, but can anyone point me in
the right direction, please.

I am doing a names and addresses database in Access 2000 for a charity in
which I also store email addresses. They want to be able to do email
mail-shots now and again, using Outlook. Is there a way of doing this,
perhaps from a query which shows title, firstname, surname, email address
(and obviously the text of the mailshot, which will be the same to every
recipient).

Laura TD

 

[Sandra Daigle]

Hi Laura,

Here are links to several articles that describe how to do this. Post back
if you have trouble trying to implement one of these:

Q161088 Using Automation to Send a Microsoft Outlook Message
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q161088

HOW TO: Use Automation to Send a Microsoft Outlook Message using Access 2000
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q209948

ACC97: How to Use a Recordset to Send Outlook E-Mail to Multiple Recipients
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q318881

Tony Toew's Email FAQ
http://www.granite.ab.ca/access/email.htm

 

[laura]

Thank you Sandra,

I think that with some modifications, once I understand it totally, this is
the one that will work for my needs..

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q318881

ACC97: How to Use a Recordset to Send Outlook E-Mail to Multiple Recipients

I will probably use a query to pick out the email addresses, but it shoudl
work - many thanks for the pointer, you've saved me a lot of time and work!

Laura TD

Hi Laura,

Here are links to several articles that describe how to do this. Post back
if you have trouble trying to implement one of these:

Q161088 Using Automation to Send a Microsoft Outlook Message
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q161088

HOW TO: Use Automation to Send a Microsoft Outlook Message using Access 2000
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q209948

ACC97: How to Use a Recordset to Send Outlook E-Mail to Multiple Recipients
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q318881

Tony Toew's Email FAQ
http://www.granite.ab.ca/access/email.htm


--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.

I am not sure if this is the right forum to ask, but can anyone point
me in the right direction, please.

I am doing a names and addresses database in Access 2000 for a
charity in which I also store email addresses. They want to be able
to do email mail-shots now and again, using Outlook. Is there a way
of doing this, perhaps from a query which shows title, firstname,
surname, email address (and obviously the text of the mailshot, which
will be the same to every recipient).

Laura TD

 

[Sandra Daigle]

You're welcome - post back if you have any trouble.

--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.

Thank you Sandra,

I think that with some modifications, once I understand it totally, this
is the one that will work for my needs..

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q318881

ACC97: How to Use a Recordset to Send Outlook E-Mail to Multiple
Recipients

I will probably use a query to pick out the email addresses, but it shoudl
work - many thanks for the pointer, you've saved me a lot of time and
work!

Laura TD

Hi Laura,

Here are links to several articles that describe how to do this. Post
back if you have trouble trying to implement one of these:

Q161088 Using Automation to Send a Microsoft Outlook Message
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q161088

HOW TO: Use Automation to Send a Microsoft Outlook Message using Access
2000 http://support.microsoft.com/default.aspx?scid=kb;en-us;Q209948

ACC97: How to Use a Recordset to Send Outlook E-Mail to Multiple
Recipients
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q318881

Tony Toew's Email FAQ
http://www.granite.ab.ca/access/email.htm


--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.

I am not sure if this is the right forum to ask, but can anyone point
me in the right direction, please.

I am doing a names and addresses database in Access 2000 for a
charity in which I also store email addresses. They want to be able
to do email mail-shots now and again, using Outlook. Is there a way
of doing this, perhaps from a query which shows title, firstname,
surname, email address (and obviously the text of the mailshot, which
will be the same to every recipient).

Laura TD