E-mail a link

[CJD#11]

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

[Static]

add a ref to MS Outlook
you also need the UNC path to the file...

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

[CJD#11]

O.k. One problem. We use GroupWise for e-mail. I know, I know. Can I just substitute GW where you have Outlook?

[CJD#11]

Got something working now. Thanks

[RobDog888]

Perhaps you could post the solution for the benefit of other members that may have the same issue?