Inserting hyperlink in Body of email sent from Access or Outlook

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?
 
A

Al Borges

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

HTML Email Code 1
Inserting a hyperlink in the body of a meeting request 3
Outlook Outlook 2010 Email Body Messages - Auto Hyperlink 2
Email using send object in an module 1
Hyperlink in body of VBA email 1
Access 2007 - Use Report or HTML file as body of Outlook email mes 3
Inserting a hyperlink into the body of an email 3
Sending Hyperlinks in Body of an email 4

Top