Hi
I am hoping somebody can help me with my issue.
I have setup a document that opens a CSV file, transfers the data and saves the file in a location but also emails before it closes. however I am getting a pop up I would like to bypass and Application.DisplayAlerts = False doesn't seem to do so.
The popup I am getting is :
Microsoft Outlook
"A program is trying to send an e-mail message on your behalf. If this is unexpected, click Deny and verify your antivirus software is up-to-date."
This has 3 buttons Allow Deny Help
Is there a way I can get this to auto allow through excel?
Many Thanks in advance.
DMK
I am hoping somebody can help me with my issue.
I have setup a document that opens a CSV file, transfers the data and saves the file in a location but also emails before it closes. however I am getting a pop up I would like to bypass and Application.DisplayAlerts = False doesn't seem to do so.
The popup I am getting is :
Microsoft Outlook
"A program is trying to send an e-mail message on your behalf. If this is unexpected, click Deny and verify your antivirus software is up-to-date."
This has 3 buttons Allow Deny Help
Is there a way I can get this to auto allow through excel?
Many Thanks in advance.
DMK