Outlook Exchange and Email Macro

[DCGPX]

I'm after some help.

I have an office that has an exchange server for Outlook.

The client now wants to use a macro within some Excel file to send data via email to another business.

His problem (now mine) is that the Excel macro brings up a security window asking to allow the email etc. He want this suppressing or bypassing as its causing a bit of complaining from his staff.

I've looked at trusted source etc but I cant get it to work with exchange.

All script/macros I've seen want to put server names in as if a local pop account but exchange doesn't work like this. I've tried various option from google and gather its not uncommon and no workaround I've come across.

Anyone seen a similar situation and the resolution used?

 

[ATTech]

Without seeing the macro's VBA code, it's hard to tell how he's trying to do it, but there is a setting in Excel to allow access to VBA objects. In 2007, it's in the trust center, under macro settings called "Trust access to the VBA project object model." That should allow him to automate tasks with other programs (such as Outlook) in his VBA code. Again though, I don't know how he's trying to do it now, so it's tough to give specific advise.

 

[DCGPX]

Should have put more detail.

Outlook is 2003 version. In VBA references I've got :

VB for applications
MS Outlook 11 Object Library
OLE Automation
MS Scripting Runtime.

All the Googling I've done says the Object Library should do it but it doesn't with Exchange.

I've tested on my own Outlook with POP accts and it works as a trusted source implied via this.

But for love nor money I cant get it to work with his Exchange setup

 

[ATTech]

Should have put more detail.

Outlook is 2003 version. In VBA references I've got :

VB for applications
MS Outlook 11 Object Library
OLE Automation
MS Scripting Runtime.

All the Googling I've done says the Object Library should do it but it doesn't with Exchange.

I've tested on my own Outlook with POP accts and it works as a trusted source implied via this.

But for love nor money I cant get it to work with his Exchange setup

It should be do-able using the application objects from VBA. Have him check the macro security settings. I've automated emails in an exchange environment using VBS utilizing the VBA objects. If his code in the problem, Google "automate outlook emails" for few articles on how to do it using the VBA objects. It doesn't, however, sound like his code is the problem, it sounds like he doesn't have the correct security settings.

 

[DCGPX]

Cheers, I'm back tomorrow for another look so I'll check and see whats what. I've only just got it this week so in research stage.