![]() |
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 need to send emails automatically using Voltage SecureMail as my attachments contains confidential info., so that the email goes Email encryption. I have created a macro to send emails automatically but need help to send them using 'Send secure' button. Therefore I need to include a code in the following macro. Any help greatly appreciated Regards, KD Sub Send_Email_Attachment() ESUBJECT = "ABC" Ebody = "Hi," & (Chr(13)) & (Chr(13)) & " Thanks for any help." & (Chr(13)) & (Chr(13)) & "Regards" & (Chr(13)) & "KD" & (Chr(13)) & (Chr(13)) con = 4 Step100: NewFileName = Range("b" & con).Value sendTo = Range("c" & con).Value If NewFileName = "" Then GoTo Step1000 Else Set obOutApp = CreateObject("Outlook.Application") obOutApp.Session.Logon Set obOutMail = obOutApp.CreateItem(0) 'Create email with attachments With obOutMail .To = sendTo .CC = "" .BCC = "" .Subject = ESUBJECT .Attachments.Add (NewFileName) .Body = Ebody ' .Display .send End With con = con + 1 GoTo Step100 End If Step1000: End Sub |
Ads |
#2
|
|||
|
|||
![]()
Is the Send Secure button added by that SecureMail software? If so you have
to ask them if the software can be called by a macro. That button is not an Outlook button so you can't just call it from the Outlook or Office object models. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Professional Programming Outlook 2007 Reminder Manager, Extended Reminders, Attachment Options http://www.slovaktech.com/products.htm "kd" wrote in message news ![]() Hi, I need to send emails automatically using Voltage SecureMail as my attachments contains confidential info., so that the email goes Email encryption. I have created a macro to send emails automatically but need help to send them using 'Send secure' button. Therefore I need to include a code in the following macro. Any help greatly appreciated Regards, KD Sub Send_Email_Attachment() ESUBJECT = "ABC" Ebody = "Hi," & (Chr(13)) & (Chr(13)) & " Thanks for any help." & (Chr(13)) & (Chr(13)) & "Regards" & (Chr(13)) & "KD" & (Chr(13)) & (Chr(13)) con = 4 Step100: NewFileName = Range("b" & con).Value sendTo = Range("c" & con).Value If NewFileName = "" Then GoTo Step1000 Else Set obOutApp = CreateObject("Outlook.Application") obOutApp.Session.Logon Set obOutMail = obOutApp.CreateItem(0) 'Create email with attachments With obOutMail .To = sendTo .CC = "" .BCC = "" .Subject = ESUBJECT .Attachments.Add (NewFileName) .Body = Ebody ' .Display .send End With con = con + 1 GoTo Step100 End If Step1000: End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Macro help | Steve[_4_] | Outlook - General Queries | 0 | November 7th 07 09:22 PM |
Macro help | Steve[_4_] | Outlook - General Queries | 0 | November 7th 07 09:22 PM |
Outlook macro abends but Word macro runs successfully | Jreue | Outlook and VBA | 0 | December 13th 06 11:55 PM |
Call macro stored in Excel workbook from Outlook's macro | Gvaram | Outlook and VBA | 5 | October 4th 06 06:26 AM |
Macro | PE | Outlook - General Queries | 2 | June 25th 06 09:34 PM |