Inserting hyperlink in Body of email sent from Access or Outlook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can anyone tell me how to create a hyperlink in VBA to a file(UNC) and insert
the link as part of the body of an email that is generated in Access.

The syntax so far which I think will work is:
DoCmd.SendObject acSendReport, stDocName, acFormatSNP, Monitor, , , _
"Assessment/Records Review Assignment", "An Assessment has been assigned
to you. See attached document for details. " & DBlocation, False

Where DBlocation is the File I want to link to. How can I get it to
actually be a hyperlink in the email body?
 
Hi:

Try code similar to this sample-

stDocName = Me![stDocName2]
stLinkCriteria = "[ACCT]=" & Me![ACCT]
DoCmd.OpenReport stDocName, acViewPreview, , stLinkCriteria
'Exit Sub
DoCmd.SendObject acSendReport, stDocName, "snapshot format", Forms![*notify
form]!, , , "Lab results from " & Forms![persmdsu]![GROUP_NAME], "The
attachment describes the results of your laboratory bloodwork or radiograph
readings. You will need the Microsoft snapshot viewer is included in
Internet Explorer 3.0 or above; if you are using Netscape or another browser
you can download the viewer at
http://support.microsoft.com/support/kb/articles/Q175/2/74.ASP free of
charge."

Regards,
Al
 
Back
Top