![]() |
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. |
|
|
Thread Tools | Search this Thread | Display Modes |
#1
|
|||
|
|||
![]()
Hi,
I use following code to create a mail using Outlook from within Excel. I created a template file (BeLUG vzw.htm) that resides in : C:\Program Files\Common Files\Microsoft Shared\Letter Now, i need to use this specific letter template. Question is: what code lines do i need to add to the code here below to create a mail with the desired letter template? Sub Mail_workbook_Outlook_1() 'Working in 2000-2007 ' source : http://www.rondebruin.nl/tips.htm Dim OutApp As Object Dim OutMail As Object Const sMsg2 = "Send methode = Outlook" szSection = "Expence" szKey = "Mail Address1" MailTo1 = GetIniKey(szFile, szSection, szKey) szKey = "Mail Address2" MailTo2 = GetIniKey(szFile, szSection, szKey) Set OutApp = CreateObject("Outlook.Application") OutApp.Session.Logon Set OutMail = OutApp.CreateItem(0) On Error Resume Next With OutMail .To = MailTo1 If MailTo2 "0" Then .CC = MailTo2 End If .Subject = wbName .Body = sMsg & vbCrLf & sMsg2 .Attachments.Add wbPathName .Display '.Send ' End With On Error GoTo 0 OutApp.Session.Logoff Set OutMail = Nothing Set OutApp = Nothing End Sub Thanks for any help. Regards, Ludo |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Word Letter Template loses Page Setup | Geoff Goodacre | Outlook - Using Contacts | 0 | July 4th 07 05:18 PM |
Creating custom template to use as corp New mail message template | Lars JJ | Outlook - Using Forms | 8 | May 15th 07 08:32 AM |
Cannot use my company logo in `send letter to contact' word template | BT-Steve | Outlook - Fax Functions | 3 | March 2nd 07 08:36 PM |
News Letter | [email protected] | Outlook Express | 3 | January 26th 07 02:11 PM |
letter | Bruce Hagen | Outlook Express | 3 | September 6th 06 09:34 PM |