|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
| Tags: email, excel, hyperlink, question, sending |
|
|
Thread Tools | Display Modes |
|
#1
July 10th 08, 06:45 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
Sending an e-mail from Excel - Hyperlink question
Hi all,
i am not a programmer, but a newbie dabbler. I am sending an e-mail via excel and want to know if it is possible to insert a hyperlink in the body of the e-mail, so that the receiver of the e-mail can just click on it to open the path, which is on our server ?? Any help is much appreciated. -- Les 
|
| Ads |
|
#2
July 10th 08, 08:02 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Sending an e-mail from Excel - Hyperlink question
Yes, such a URL would look like this:
file://\\ourserver\ourshare\outfolder\ourfile.xls or file://z:\outfolder\ourfile.xls If the file or folder name contains spaces, you'll need to replace each space in the URL with %20. If the message is in plain text format, you can simply include the URL in the Body property. If the message is in HTML format, you'll need to include a full a tag in the HTMLBody property, just as you would in a web page. -- Sue Mosher, Outlook MVP Author of Microsoft Outlook Programming: Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Les" wrote: Hi all, i am not a programmer, but a newbie dabbler. I am sending an e-mail via excel and want to know if it is possible to insert a hyperlink in the body of the e-mail, so that the receiver of the e-mail can just click on it to open the path, which is on our server ?? Any help is much appreciated. -- Les
|
|
#3
July 10th 08, 08:31 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Sending an e-mail from Excel - Hyperlink question
Thanks Sue, what about just to a folder ??
-- Les "Sue Mosher [MVP-Outlook]" wrote: Yes, such a URL would look like this: file://\\ourserver\ourshare\outfolder\ourfile.xls or file://z:\outfolder\ourfile.xls If the file or folder name contains spaces, you'll need to replace each space in the URL with %20. If the message is in plain text format, you can simply include the URL in the Body property. If the message is in HTML format, you'll need to include a full a tag in the HTMLBody property, just as you would in a web page. -- Sue Mosher, Outlook MVP Author of Microsoft Outlook Programming: Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Les" wrote: Hi all, i am not a programmer, but a newbie dabbler. I am sending an e-mail via excel and want to know if it is possible to insert a hyperlink in the body of the e-mail, so that the receiver of the e-mail can just click on it to open the path, which is on our server ?? Any help is much appreciated. -- Les
|
|
#4
July 10th 08, 08:34 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Sending an e-mail from Excel - Hyperlink question
Same syntax; omit the file name.
-- Sue Mosher, Outlook MVP Author of Microsoft Outlook Programming: Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Les" wrote: Thanks Sue, what about just to a folder ?? -- Les "Sue Mosher [MVP-Outlook]" wrote: Yes, such a URL would look like this: file://\\ourserver\ourshare\outfolder\ourfile.xls or file://z:\outfolder\ourfile.xls If the file or folder name contains spaces, you'll need to replace each space in the URL with %20. If the message is in plain text format, you can simply include the URL in the Body property. If the message is in HTML format, you'll need to include a full a tag in the HTMLBody property, just as you would in a web page. "Les" wrote: Hi all, i am not a programmer, but a newbie dabbler. I am sending an e-mail via excel and want to know if it is possible to insert a hyperlink in the body of the e-mail, so that the receiver of the e-mail can just click on it to open the path, which is on our server ?? Any help is much appreciated. -- Les
|
|
#5
July 10th 08, 08:40 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Sending an e-mail from Excel - Hyperlink question
Thanks Sue, your a star... :-0)
-- Les "Sue Mosher [MVP-Outlook]" wrote: Same syntax; omit the file name. -- Sue Mosher, Outlook MVP Author of Microsoft Outlook Programming: Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Les" wrote: Thanks Sue, what about just to a folder ?? -- Les "Sue Mosher [MVP-Outlook]" wrote: Yes, such a URL would look like this: file://\\ourserver\ourshare\outfolder\ourfile.xls or file://z:\outfolder\ourfile.xls If the file or folder name contains spaces, you'll need to replace each space in the URL with %20. If the message is in plain text format, you can simply include the URL in the Body property. If the message is in HTML format, you'll need to include a full a tag in the HTMLBody property, just as you would in a web page. "Les" wrote: Hi all, i am not a programmer, but a newbie dabbler. I am sending an e-mail via excel and want to know if it is possible to insert a hyperlink in the body of the e-mail, so that the receiver of the e-mail can just click on it to open the path, which is on our server ?? Any help is much appreciated. -- Les
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Sending outlook mail from excel using VBA | Thirusivamani | Outlook and VBA | 1 | June 6th 08 02:12 PM |
| Mail Sending Question | Dana DeLouis | Outlook - General Queries | 4 | May 23rd 08 02:09 PM |
| sending mails from excel...but mail body disappearing | Jithu | Outlook and VBA | 0 | January 10th 08 12:57 PM |
| Sending Mail from Excel with VBA | RFraley | Outlook and VBA | 4 | November 9th 06 04:33 PM |
| Problem sending mail via excel | Jas | Outlook and VBA | 2 | April 8th 06 08:44 PM |
Linear Mode
