SendObject to email recipients in a field

[csunsun]

hi,

i wanted to run the send object function to send an auto response email to multiple email recipients in a field of a table.

how can i write this??

i already tried

[TBL Daily Import Test]![RequestorEmail] in the "To" part of the macro....


Thanks!

 

[TomCologne]

How about posting the complete code?


TomCologne

 

[csunsun]

i just wrote that in the macro...haven't done any coding.

thanks

 

[TomCologne]

Sorry, I know zip about macros because I never use them.

There are good reasons for using code instead of macros in general. Switching is easy, just see VBA Help "Convert macros to Microsoft Visual Basic".

Also, search Tek-Tips, "Search Posts" option, keyword "SendObject", there are lots of posts.

An alternative method here:

VBA code E-Mail method (better than SendObject)
Microsoft: Access Modules (VBA Coding) FAQ/faq705-537


TomCologne

 

[csunsun]

Ok,

here is the code!

Option Compare Database

'------------------------------------------------------------
' TEST_AUTO
'
'------------------------------------------------------------
Function TEST_AUTO()
On Error GoTo TEST_AUTO_Err

DoCmd.SendObject acQuery, "Query2", "HTML(*.html)", "[TBL Daily Import Test]![RequestorEmail]", "", "", "TESTiNG", "testing123", False, ""


TEST_AUTO_Exit:
Exit Function

TEST_AUTO_Err:
MsgBox Error$
Resume TEST_AUTO_Exit

End Function

Thanks!!