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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Automatically Send a notification email once a record is added 0
Windows 10 operating system - using firefox browser - yahoo mail. 5
Add New Record Button: How to Get Mouse Cursor in Specific Field Upon Clicking? 1
Sky e-mail via outlook 2
e-mail access 2003 4
Open Report using current record 15
Create an E-Mail field on a form 8
Create a icon. 3

Back
Top