Hyperlink in Outlook Email

[Holli]

If someone could please help, at a lost.



I am currently making changes to an existing database. One of the requirements is to change the [Path] to a hyperlink when it auto populates in Outlook.

The existing code works perfectly. The end user can paste the information in the database and the path is followed but not in the email.

I would like the [Path] to populate as a hyperlink in the email.

below is the code.

Thanks for your help.

email_subject = "PLEASE NOTE: Changes for Section #" & [Request Number].Value & " - " & [Request Title].Value
email_body = "Please make note of the following changes to the request mentioned below:"
email_body = email_body & Chr(10) & Chr(13)
email_body = email_body & Chr(10) & Chr(13)
email_body = email_body & "Please review the latest version of your request form and reply with your approval." & Chr(13) & Chr(10)
email_body = email_body & Chr(13) & Chr(10)
email_body = email_body & [Path]
email_body = email_body & Chr(10) & Chr(13)
email_body = email_body & "Request #: " & [Request Number].Value & Chr(13)
email_body = email_body & "Request Name: " & [Request Title].Value & Chr(13)
email_body = email_body & "QA Due Date: " & QA_Due_Date.Value & Chr(13)
email_body = email_body & "WF Due Date: " & WF_Due_Date.Value & Chr(13)
email_body = email_body & "File Due Date: " & File_Due_Date.Value & Chr(13)
email_body = email_body & "Launch Date: " & Launch_Date.Value & Chr(13) & Chr(10)
email_body = email_body & "Developer: " & Developer.Value & Chr(13)
email_body = email_body & "QA Assigned To: " & QAer.Value & Chr(13) & Chr(10)
email_body = email_body & Chr(13) & Chr(10) & Chr(13) & Chr(10)

[trevor40]

Were's the hyperlink field ?

[Holli]

The [Path] is where the hyperlink is pasted into a text box "email_body = email_body & [Path]" in the form.

Thanks trevor40

Holli

[trevor40]

ok, try putting & Chr(13) & Chr(10) OR VbCrLf after the [path], i think that because your adding the address with code it isn't seeing it as an address but as text, perhaps the return after the text may convert it to an address, if not you may have to try using HTML tags to add it, try a search for html code tags and address. if that works you will have to use htmlbody. in place of just body.