vba to send email using Outlook and Voltage

scottc_00

New Member
Joined
Feb 14, 2006
Messages
13
I have an Excel macro that will loop thru a list of ID's and send each one an email using Outlook. Everything works fine.
The problem is that there is sensitive data in the emails. In my company when sending sensitive data in emails you must "Send Secure" using the Outlook plugin "Voltage".

A colleague has gotten this to work using vb.net but neither he nor I can get it to work on vba.
The method in vb.net is to create a custom header for the email (Arguments in vb.net are "X-App-Volt", "Yes").

I looked at the differences between a secure email header and an unsecure email header and attempted to use some of the properties to recreate those differences.
Apparently you can use .PropertyAccessor.SetProperty ... to send secure but I can get it to work.

Does anyone have any experience creating a macro that will send secure mail using the Voltage Plugin for outlook?

Normally when I have a problem like this I will record a macro as a starting point and then figure out how to modify it for my purposes.
But apparently there is NO WAY to record a macro in Outlook.

Thanks
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

Forum statistics

Threads
1,137,124
Messages
5,679,743
Members
419,854
Latest member
marvin24

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top