Code: Select all
Dim strTopic As String
Dim strMBody As String
Dim strExcelFile As String
Dim strAttachment As String
strTopic = "Updated file now available"
strMBody = "The update Excel Spreadsheet is now at 'I:\Confidential\MedicalNotes\GriffinsNotes\LatestReport.xls' "
strAttachment = "C:\AIRR\Logo.jpg"
SendMail "alan.ladd@mgm.com", "", "", strTopic, strMBody, strAttachment, ShowMail:=True
I tried using
Code: Select all
strMBody = "The update Excel Spreadsheet is now at "<a href= " & Chr(34) & "'I:\Confidential\MedicalNotes\GriffinsNotes\LatestReport.xls" & Chr(34) & ">I:\Confidential\MedicalNotes\GriffinsNotes\LatestReport.xls</a> "
I did find this post but I couldn't figure out how to use it for the above purposes.
NOTE: Before you ask, the reason the spreadsheet is not included as an attachment is for privacy reasons and the confidentiality of the data in the spreadsheet.
Thanks in a advance for your ideas and suggestions.
Ken