Inserting variables into Hyperlink Address

[Lateral]

Hi guys

I'm a newbie I'm using Access 2007.

I have a customer table attached to a form.

I want to put a command button next to the customer's email address so that the user simply presses the button and Outlook will be started with the customer's email address automatically inserted from the table.

I am playing around with the Hyperlink Address function and whilst this seems to do what I want, I can't figure out how to get the customer's email address from the tabel and insert it......

Any help will be greatly appreciated.

Thanks
Regards
Greg

 

[pbaldy]

I would use SendObject with a reference to the form in the To argument.

 

[Lateral]

Thanks for the reply.

I have used send object successfully but it only appears to send in text format without the email signature whereas the hyperlink method appears to use HTML format and does insert the signature.

 

[pbaldy]

Well, if you show that code we can figure out how to add the address.

 

[Lateral]

Hi Paul

I'm not sure what you are asking for.

I'm just creating a Command button and changing the Property setting "HyperLink Address".

Where can I find the "code" that you are refering to?

Regards
Greg

 

[pbaldy]

There's either VBA code or a macro behind the button.

 

[Lateral]

How do I see it?

 

[pbaldy]

http://www.baldyweb.com/FirstVBA.htm

 

[Lateral]

Hi Paul

I have attached 2 screen shots of what I am seeing when I click on the three dots. "...". I am not seeing any VBA code. Also, there is no Event Procedure setting in the On Click property.

Regards
Greg

 

[pbaldy]

Sorry, I haven't used that method. In a brief test, I could get it to work with a hard-coded address but not by referring to the form. In VBA code, this would work:

DoCmd.SendObject , , , Me.EmailAddress, , , "Subject", "Body"

 

[Lateral]

Hi Paul

Yeah, I could also get it to work with a hard-coded address and with VBA.

It sure would be nice to have an HTML version of the VBA method....any ideas?

Thanks
Regards
Greg

 

[pbaldy]

You could try this in VBA:

Application.FollowHyperlink "MailTo:" & Me.EmailAddress

Might need tweaking, as I'm not sure of the syntax for MailTo, but the idea is to build the hyperlink in code.

 

[Lateral]

Thanks Paul,

I'll have a play an let you know.

Thanks
Regards
Greg

 

[pbaldy]

No problem Greg. It should work, it's just a matter of finding the correct syntax for the hyperlink, which you might be able to get from your button, concatenating the form reference where the hard-coded email address was.