A Microsoft Outlook email forum. Outlook Banter

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.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Macro Using voltage securemail



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old May 2nd 08, 08:11 AM posted to microsoft.public.outlook.program_vba
kd
external usenet poster
 
Posts: 4
Default Macro Using voltage securemail


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  
Old May 2nd 08, 01:50 PM posted to microsoft.public.outlook.program_vba
Ken Slovak - [MVP - Outlook]
external usenet poster
 
Posts: 5,848
Default Macro Using voltage securemail

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
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


All times are GMT +1. The time now is 04:14 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.