Email Hyperlink in Access form

Question

I have a Form called Buyers/Sellers.  I use it in Datasheet view.  One of the fields (Named: EMail) stores email address.

I would like the ability to click on any one of the email addresses that I chose, and have it open up new email message window with the email address already in the "To" box.

I have tried the "EMailDatabaseObject" Macro in the "On Click" in the properties for the field, but this is not quite what I want.  I would like for a new email message window to pop up without any attachments.

Thank you !!

Answer 1

Did you put anything in the To box in the macro?

What should be there is:

=Forms!formname!controlname

where formname is the name of your form and controlname the name of the control bound to your e-mail field.

Answer 2

Hi Scott,

Excellent!!  Thank you very much!!!  The To box is populating.

Is there any way that I can get my Outlook email signature at the bottom of the email.  It has 4 lines.  My name, Company name, Phone, and Fax.

I see where you can add a line where it says Message Text, but you cannot put multiple lines there.

Thanks again!!

Answer 3

Hi Scott,

In the properties for that field in the "On Click" box, I clicked the box on the far right with the 3 dots. I clicked Macro Builder.  I select "EMailDatabaseObject."

I leave everything blank in Object Name, Object Type.  I have "Yes" in Edit Message.

When I close and use this macro on by clicking on the field, it does open the email new message box, but there is nothing in the "To" box.

I was hoping to have it open a new message box with the email address already in the To box, and maybe even have the same signature information that I normally have on my Outlook emails at the bottom.  Just like if you click on an email hyperlink in Excel or Word.

Thanks Scott!!

Answer 4

Show us how you coded the macro. Or look at the SendObject method.