Is there any code/function that would allow me to e-mail a link? I am saving a report out to a network share and then need to send out an e-mail when the report is ready with a link to it's location. Thanks
Printable View
Is there any code/function that would allow me to e-mail a link? I am saving a report out to a network share and then need to send out an e-mail when the report is ready with a link to it's location. Thanks
add a ref to MS Outlook
you also need the UNC path to the file...
VB Code:
Dim Otl As Outlook.Application Set Otl = New Outlook.Application Dim oMail As Outlook.MailItem Set oMail = Otl.CreateItem(olMailItem) oMail.To = "Who??" oMail.Subject = "Here is the link to the new file" oMail.Body = "\\UNC_NAME\Filename.txt" oMail.Display
O.k. One problem. We use GroupWise for e-mail. I know, I know. Can I just substitute GW where you have Outlook?
Got something working now. Thanks
Perhaps you could post the solution for the benefit of other members that may have the same issue? :)