![]() |
| 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. |
|
|||||||
| Tags: behalf, message |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
|
Hello, I am programming a VBA in Excells and I am getting the Error message "A Program is trying to send an e-mail message on your behalf..." , please let me know the code to eliminate this Sheet4.Select Cells.Select Selection.Copy Workbooks.Add ActiveSheet.Paste ActiveWorkbook.SendMail ", "Test" Thanks |
| Ads |
|
#2
|
|||
|
|||
|
See http://www.outlookcode.com/article.aspx?ID=52 for your options with
regard to the "object model guard" security in Outlook. -- Sue Mosher, Outlook MVP Author of Microsoft Outlook Programming: Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Test" wrote: Hello, I am programming a VBA in Excells and I am getting the Error message "A Program is trying to send an e-mail message on your behalf..." , please let me know the code to eliminate this Sheet4.Select Cells.Select Selection.Copy Workbooks.Add ActiveSheet.Paste ActiveWorkbook.SendMail ", "Test" |
|
#3
|
|||
|
|||
|
Hi Sue,
I tried the link, but no luck. I need a VBA code in Excel to bypass the error message Thanks "Sue Mosher [MVP-Outlook]" wrote in message ... See http://www.outlookcode.com/article.aspx?ID=52 for your options with regard to the "object model guard" security in Outlook. -- Sue Mosher, Outlook MVP Author of Microsoft Outlook Programming: Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Test" wrote: Hello, I am programming a VBA in Excells and I am getting the Error message "A Program is trying to send an e-mail message on your behalf..." , please let me know the code to eliminate this Sheet4.Select Cells.Select Selection.Copy Workbooks.Add ActiveSheet.Paste ActiveWorkbook.SendMail ", "Test" |
|
#4
|
|||
|
|||
|
Hello,
You can download a programme that clicks yes for you from here, it is free.... http://www.snapfiles.com/get/clickyes.html -- Les "Test" wrote: Hello, I am programming a VBA in Excells and I am getting the Error message "A Program is trying to send an e-mail message on your behalf..." , please let me know the code to eliminate this Sheet4.Select Cells.Select Selection.Copy Workbooks.Add ActiveSheet.Paste ActiveWorkbook.SendMail ", "Test" Thanks |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Send Message on Behalf Question | Eka1618 | Outlook and VBA | 3 | June 30th 08 07:31 PM |
| Message sent on behalf | KeithMeister | Outlook - Installation | 3 | October 16th 07 04:04 PM |
| sent on behalf of - how do I set it up in Outlook? | Blondie as a PA | Outlook - Calandaring | 0 | May 24th 06 01:21 PM |
| Sent on behalf of | NickWatkins2006 | Outlook - Installation | 3 | April 6th 06 08:57 AM |
| send on behalf | BINZA@ | Outlook - General Queries | 3 | February 8th 06 03:30 AM |