how do I email from a query

[Guest]

Is there a way to populate the To: field in Outlook from the results of a
query?

 

[Rick B]

I don't think you can do it in a query, but you can do it in a form using
code.

 

[Guest]

Thanks Rick, how???

I don't think you can do it in a query, but you can do it in a form using
code.

 

[Rick B]

Create code using the DoCmd.SendObject method

You can tie this to a button if you want and the user can click the button
to create an email.

Assuming you don't want to send any particular object (just open a blank
email) your code would look something like:


Private Sub Command45_Click()
DoCmd.SendObject acSendNoObject, , , [EmailAddressFieldName]
End Sub



Obviously you can make this as comples as you want. You can include some
erro checking, have it attach a report, etc.

 

[Guest]

Thanks Rick, I'll give it a shot.

Create code using the DoCmd.SendObject method

You can tie this to a button if you want and the user can click the button
to create an email.

Assuming you don't want to send any particular object (just open a blank
email) your code would look something like:


Private Sub Command45_Click()
DoCmd.SendObject acSendNoObject, , , [EmailAddressFieldName]
End Sub



Obviously you can make this as comples as you want. You can include some
erro checking, have it attach a report, etc.

--
Rick B

Thanks Rick, how???