Using VB code to send Auto Response Emails

[csunsun]

Hi,

I want to import MS Excel spreadsheets to an MS Access db and send auto response emails to recipients listed in the spreadsheet.

Any helpful tips?

I am assuming:

1. import spreadsheet (with email recipients)
2. open data access page (with email text)
3. send object (to recipient on imported spreadsheets)

Can I write code to say send this page to all recipients in Email field in Daily table??

Thanks!

 

[Remou]

Have you looked at SendObject? You will also find quite a lot on email in the FAQs.

 

[csunsun]

HI,

Yes I have checked it out...

I jut need to know how to send the emails to all recipients in a field in the table I am importing since the recipients will change daily. Seems as though you can only type in a specific email address or name of a distribution list....

Anyone know how to do this? I tried to build an expression [Daily Table]![Email Address]in the "To" field...but there was an error.

Thanks!

 

[Remou]

What code did you try?

 

[csunsun]

Here is what I tried...

DoCmd.SendObject , "", "", "[TBL Daily Credit Requests]![F1]", "", "", "Your Credit Request Has Been Received by LowerMyBills.com", "Hi, Please allow 14 days to receive your credit. ", False,

 

[Remou]

Do not put quotes around the form or table data:
[tt]DoCmd.SendObject , "", "", [TBL Daily Credit Requests]![F1], "", "", "Your Credit Request Has Been Received by LowerMyBills.com", "Hi, Please allow 14 days to receive your credit. ", False, ""[/tt]

I am not sure if [TBL Daily Credit Requests]![F1] is from a form or table, the format looks like a form, but the name looks like a table.
It is possible to loop through recordsets and send to each person. You will find quite a few posts on this topic, for example:
SendObject Method: e-mail to list with VBA
thread181-55134