|
|
|
|
|||||
|
|
|
|
|
|
|||
| Welcome
to Tech Support Forum home to more then 136,000 problems solved. Issues
have included: Spyware, Malware, Virus Issues, Windows, Microsoft,
Linux, Networking, Security, Hardware, and Gaming Getting your
problem solved is as easy as: 1. Registering for a free account 2. Asking your question 3. Receiving an answer Registered members: * See fewer ads. * And much more..
|
| Want to know how to post a question? click here | Having problems with spyware and pop-ups? First Steps |
|
|||||||
| Microsoft Office support MS Office support forum |
 |
|
|
LinkBack | Thread Tools |
04-04-2008, 10:09 AM
|
#1 (permalink) |
|
Registered User
Join Date: Apr 2007
Posts: 60
OS: xp pro
|
hyperlink in email macro
Hi All
I am using the following VB code to email a excel document as an attachment. What I actually want to do is email the body of the text with a hyperlink to the location on our server. HTML Code:
Dim myOutlook As Object
Dim myMailItem As Object
Set otlApp = CreateObject("Outlook.Application")
Set otlNewMail = otlApp.CreateItem(olMailItem)
fName = ActiveWorkbook.Path & "\" & ActiveWorkbook.Name
With otlNewMail
.To = "peter.bryant@martinluck.co.uk"
.Subject = "Duplicate Order Report"
.Body = "Please find attached the Duplicate Orders Report for the week commencing ." & Chr(13) & "Regards," & Chr(13) & "It Team" & Chr(13)
' .Attachments.Add fName
.Send
End With
Set otlNewMail = Nothing
Set otlApp = Nothing
Set otlAttach = Nothing
Set otlMess = Nothing
Set otlNSpace = Nothing
|
|
     
|
| Important Information |
|
Join the #1 Tech Support Forum Today - It's Totally Free!
TechSupportForum.com is a leading support website for your computer needs. We offer free, friendly and personalized computer support. Why pay to have your computer fixed when you can do it for free. Join TechSupportforum.com Today - Click Here |
|
04-07-2008, 01:26 AM
|
#2 (permalink) |
|
Registered User
Join Date: Apr 2007
Posts: 60
OS: xp pro
|
Re: hyperlink in email macro
Has anyone got any suggestions for this.
I know I could send it as an attachment instead of a link but our email server is getting full even with archiving so a link to the company shared drive is much more suitable. |
|
|
|
|
04-07-2008, 04:09 PM
|
#3 (permalink) |
|
Moderator/ Rangemaster TSF Academy; Analyst, Security Team; Oor Wullie; TSF Surgeon and Resident Comic
|
Re: hyperlink in email macro
Hi
Not my favourite Excel topic, but Ron de Bruin is the master when it comes to e-mailing from Excel. He may well even have an Add-in that would help.
__________________
Iain - Defender of the Haggis and all things Scottish. I don't help by PM - post in the Forums.   PC Safety & Security::PC running a bit slow?::Donate::Photographers Corner |
|
|
|
|
| Thread Tools | |
|
|
