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

Message on Behalf



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old July 7th 08, 07:04 PM posted to microsoft.public.outlook.program_vba
Test
external usenet poster
 
Posts: 9
Default Message on Behalf


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  
Old July 7th 08, 07:34 PM posted to microsoft.public.outlook.program_vba
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default Message on Behalf

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  
Old July 7th 08, 09:46 PM posted to microsoft.public.outlook.program_vba
Test
external usenet poster
 
Posts: 9
Default Message on Behalf

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  
Old July 10th 08, 08:26 PM posted to microsoft.public.outlook.program_vba
Les
external usenet poster
 
Posts: 17
Default Message on Behalf

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 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
Send Message on Behalf Question Eka1618 Outlook and VBA 3 June 30th 08 08:31 PM
Message sent on behalf KeithMeister Outlook - Installation 3 October 16th 07 05:04 PM
sent on behalf of - how do I set it up in Outlook? Blondie as a PA Outlook - Calandaring 0 May 24th 06 02:21 PM
Sent on behalf of NickWatkins2006 Outlook - Installation 3 April 6th 06 09:57 AM
send on behalf BINZA@ Outlook - General Queries 3 February 8th 06 04:30 AM


All times are GMT +1. The time now is 08:39 PM.


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.