471,354 Members | 1,559 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,354 software developers and data experts.

DoCmd.SendObject help

I am using Access 2000 and need a little help writing the code the
proper way to do the following:

I have a form with the following fields: "Requestor" and
"RequestorEmailAddress"
I have a subform with the following fields: "OpenPoNumber"

I want to use the DoCmd.SendObject to send an email of the form to the
Requestors email address.

Can someone please help with this?

I have used macros before to send emails, but they do not allow you to
use data from the form as an email address.

Thanks

Jan 11 '07 #1
1 2097
DoCmd.SendObject , , acFormatTXT, Me![RequestorEmailAddress], , , "Subject",
"Message", True

Note: this will create but not send the message using your default email
client.

<bg********@yahoo.comwrote in message
news:11**********************@k58g2000hse.googlegr oups.com...
I am using Access 2000 and need a little help writing the code the
proper way to do the following:

I have a form with the following fields: "Requestor" and
"RequestorEmailAddress"
I have a subform with the following fields: "OpenPoNumber"

I want to use the DoCmd.SendObject to send an email of the form to the
Requestors email address.

Can someone please help with this?

I have used macros before to send emails, but they do not allow you to
use data from the form as an email address.

Thanks

Jan 11 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Lauren Quantrell | last post: by
5 posts views Thread by Tom Louchbaum | last post: by
reply views Thread by XIAOLAOHU | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.