Emailing in Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

b_a_redman - 21 Jun 2007 11:20 GMT

I have a table where one column stores email addresses, i want to create a
form where by i can select these email addresses i want to send to, put a
message in a text box, have my email address as the sender, and then be able
to complete this with a button. My assumpition is that this information will
then be taken and pupulated in microsoft outlook. Can someone give me as much
infortion and code for this as possible please?

Reply to this Message

Daniel - 21 Jun 2007 13:11 GMT

you can use 2 approaches.

1. use the sendobject method. this is good for simple messages (which can
include database objects such as reports).

There is tons a info on the sendobject method. simply look in the vba help
for the synthax and example. it is very straight forward to use.

2. automate outlook. this is good for complexe messages requiring
attachments....

A few good sources of info are:
http://www.cardaconsultants.com/en/msaccess.php?lang=en&id=0000000013
http://msdn2.microsoft.com/en-us/library/aa159619(office.11).aspx

Your basic idea is sound.
Create a form with a list box to select the recipients and a textbox to
create you message in and a button to fire off the message.

Signature

Hope this helps,

Daniel P

> I have a table where one column stores email addresses, i want to create a
> form where by i can select these email addresses i want to send to, put a
> message in a text box, have my email address as the sender, and then be able
> to complete this with a button. My assumpition is that this information will
> then be taken and pupulated in microsoft outlook. Can someone give me as much
> infortion and code for this as possible please?

Reply to this Message