How to keep track of emails sent 1

[Dophia]

Hello Everyone: I was able to follow other posts and have a button on my form to send an email with information from the form.

I would like to take this further, as follows:

1) Send the email to email addresses on file

2) Keep track whether or not the email was sent, in Access.

Any suggestions would be very much appreciated.

Sophia

 

[Andrzejek]

Loop thru "email addresses on file" and for every address send an e-mail.

You can have a little table in Access where every time "a button on my form to send an email with information " is clicked you Insert a record:

Table: E_Mail_Notifications
ID (PK)
DateSent Date, default Now
From (Text)
To (Text)
Cc (Text)
Subject (Text)
Body (Text)

Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.

 

[Dophia]

Hello Andy:

Thank you for your reply.

What do you mean by your statement: Loop thru "email addresses on file" and for every address send an e-mail.

How would I accomplish that and why would I do that for every address on file?

Sophia

 

[Andrzejek]

From your original post I get that you can send an e-mail to an address, and that works fine.

So when you said:
"1) Send the email to email addresses on file"
I assume you have a file (a text file?) that looks something like this:
[tt]
abcd@domain.com
BBrown@microsoft.com
SSmith@pbs.org[/tt]

and you want to send e-mail notification to those (3) addresses. (Is that right?)

That's why I said: "Loop thru "email addresses on file" and for every address send an e-mail." Since you can send one e-mail to one address, you should be able to send this e-mail to 3 addresses from your file by looping thru the addresses. Right?

Or am I missing something here?

Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.

 

[Dophia]

Hi Andy: I understand now. I just meant that the user would choose one or more of the email addresses on file to send the email to.

I will try what you suggested, tonight, and let you know.
Thank you for you help.
Sophia

 

[Andrzejek]

You refer to "email addresses on file". Do you mean "email addresses in the Access table"? Or "email addresses in the text file"?
In any case, you may want to display the "email addresses on file" in a multi-select list box on the Form so the User can select one or many addresses before clicking on "Send" an E-Mail notification command button.

Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.