How do I create a "Send" button that uses a record's "e-mail" fiel

N

NDMac

Anyone know how I can create a button that will open up a new Outlook message
with the e-mail address from a record field?
 
G

Graham Mandeno

The easiest way is to use SendObject:

DoCmd.SendObject To:=Me.EmailAddress

You can also add other arguments, such as Subject and MessageText...

DoCmd.SendObject To:=Me.EmailAddress, Subject:="Your account", _
MessageText:="blah blah"

If you want to send the message without editing, add EditMessage:=False
 
N

NDMac

Worked perfectly. Thank you.

Graham Mandeno said:
The easiest way is to use SendObject:

DoCmd.SendObject To:=Me.EmailAddress

You can also add other arguments, such as Subject and MessageText...

DoCmd.SendObject To:=Me.EmailAddress, Subject:="Your account", _
MessageText:="blah blah"

If you want to send the message without editing, add EditMessage:=False
--
Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand


NDMac said:
Anyone know how I can create a button that will open up a new Outlook
message
with the e-mail address from a record field?
Click to expand...
Click to expand...
 
Top