Larry Brister
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.
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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"
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.
ASKER
LSM...
Yes
Yes
Then just do as I suggested - set the value of strMailTo to your static value.
ASKER
Thanks
ASKER
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