feathers212
03-28-2007, 01:18 PM
I have an excel file that gets saved in a folder. When a user clicks a button, an email is sent with the following information. How do I make it so the “Verification Needed” portion of the body acts as a hyperlink to the following network folder?
V:\press\Forum\Count Control\Pull Tickets\Verification Needed\
Here is my code:
Set WB = ActiveWorkbook
FileName = "Pressroom Pulled Job.xls"
ChDrive "V"
ChDir "V:\press\Forum\Count Control\Pull Tickets\Verification Needed\"
WB.SaveAs FileName
WB.Close SaveChanges:=False
'Create and show the outlook mail item
Set oApp = CreateObject("Outlook.Application")
Set oMail = oApp.CreateItem(0)
With oMail
.To = "hello.world@domain.com"
'.CC = ""
.Subject = "Verify Pressroom Pulled Job Counts"
. Body = "A pull ticket has been submitted. Please check the Verification Needed folder.”
.Display
End With
EDIT: email address masked by mvidas
V:\press\Forum\Count Control\Pull Tickets\Verification Needed\
Here is my code:
Set WB = ActiveWorkbook
FileName = "Pressroom Pulled Job.xls"
ChDrive "V"
ChDir "V:\press\Forum\Count Control\Pull Tickets\Verification Needed\"
WB.SaveAs FileName
WB.Close SaveChanges:=False
'Create and show the outlook mail item
Set oApp = CreateObject("Outlook.Application")
Set oMail = oApp.CreateItem(0)
With oMail
.To = "hello.world@domain.com"
'.CC = ""
.Subject = "Verify Pressroom Pulled Job Counts"
. Body = "A pull ticket has been submitted. Please check the Verification Needed folder.”
.Display
End With
EDIT: email address masked by mvidas