#1
|
|||
|
|||
send to Mail recipient
hello dears
i'm facing great problem, in my work need to attach many files via Send To Mail recipient ms-outlook always send message format blain-text which not readable in many computers cause of unicode and we lose formatting. how i make it send as default format html? could i able to modify this shortcut in send to foldar? any help will be appreciated. |
#2
|
|||
|
|||
You are only using part of Outlook. Either create the mail from Outlook or use VBA to access the full version of Outlook.
This code goes in Excel. I changed it a little. The source: http://msdn.microsoft.com/en-us/libr...ffice.11).aspx Code:
Sub Mail_Workbook_1() ' Works in Excel 2000, Excel 2002, Excel 2003, Excel 2007, Excel 2010, Outlook 2000, Outlook 2002, Outlook 2003, Outlook 2007, Outlook 2010. ' Likely works in more recent versions ' This example sends the last saved version of the Activeworkbook object . Dim OutApp As Object Dim OutMail As Object Set OutApp = CreateObject("Outlook.Application") Set OutMail = OutApp.CreateItem(0) On Error Resume Next ' Change the mail address and subject in the macro before you run it. With OutMail .To = "put address here or leave blank to enter manually" .CC = "" .BCC = "" .Subject = "This is the Subject line" .Body = "Hello World!" .Attachments.Add ActiveWorkbook.FullName ' You can add other files by uncommenting the following line. '.Attachments.Add ("C:\test.txt") ' display the mail. .Display End With On Error GoTo 0 Set OutMail = Nothing Set OutApp = Nothing End Sub |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to send several rows of data from one column to each recipient in one go | mikustykus | Mail Merge | 14 | 09-30-2013 08:32 AM |
word 2003 send to recipient as mail attachment is missing | taso | Word | 0 | 06-14-2013 11:39 AM |
Using Outlook 2007 & Office 2013 - Send To Mail Recipient. | Mattycee | Outlook | 0 | 04-07-2013 05:38 PM |
Word 2010 setting defaults for send to mail recipient | yancyxc | Word | 0 | 06-28-2011 05:07 AM |
"Send to" mail recipient | forlino | Mail Merge | 0 | 03-17-2010 10:26 AM |