Link to home
Start Free TrialLog in
Avatar of Larry Brister
Larry BristerFlag for United States of America

asked on

VBA Code Email link with Body HTML?

From MS Access vbs is it possible to make the url a html hyperlink?

I would assume that the modification would be in the bode= section


MY current code that works...
Just want it to say "Click Here" instead of the whole url.

'Add client email
strMailTo = "mailto:" & Me.Parent.email

'Add Subject Field
strMailTo = strMailTo & "&subject=Your%20Account%20Team"


'Add Body Field
strMailTo = strMailTo & "&body=http://www.mydomain.net/Videos/ClientVideo.aspx%3Fq=" & cid

Application.FollowHyperlink strMailTo

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Larry Brister

ASKER

Lsm...
The link is fine but I need to send it to a particular email address...not someone in my Contacts List.

Looks like I need to use the ".To" code but I can't find how to include all the argumets for that
I don't follow - you asked how to make the url a html hyperlink, and your followup doesn't seem to have anything to do with that.

Can you explain further? Do you mean that you need to send the email to a static address, like:

'Add client email
strMailTo = "mailto:someone@somewhere.com"
LSM...
Yes
Then just do as I suggested - set the value of strMailTo to your static value.
Thanks