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

Using Item.Send to e-mail from Access through Outlook 2003 with multiple recipients



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old December 1st 06, 09:47 PM posted to microsoft.public.outlook.program_vba,microsoft.public.outlook.general
Tuck 'n Roll
external usenet poster
 
Posts: 1
Default Using Item.Send to e-mail from Access through Outlook 2003 with multiple recipients

Greetings all,
I have created a form in Access 2003 that uses Outlook 2003 to e-mail a
report to about 20 of my employees. It works fine with the exception that
it pauses and prompts me to click "Yes" or "No" for each recipient, and it
delays for 5 seconds between each confirmation. I know this is some
anti-Spamming feature that Outlook has, but I imagine that there has to be a
way for me to send this report without having to sit there and click "Yes"
every 5 seconds. Here is the help text for the error:

A program is trying to send mail using Item.Send
A program is trying to automatically send an e-mail message using a
Microsoft Visual Basic Application (VBA) command, Item.Send, from within
Microsoft Outlook. If you want this program to send this message, click Yes.
To stop the program, click No. If you are unsure which program is sending
the message or why the message is being sent, you should click No to help
avoid the possible spread of viruses.

Note When this message is displayed, the Yes button is not available for
five seconds

I appreceate any and all help.
Regards,

Al


Ads
  #2  
Old December 1st 06, 10:02 PM posted to microsoft.public.outlook.program_vba,microsoft.public.outlook.general
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default Using Item.Send to e-mail from Access through Outlook 2003 with multiple recipients

See http://www.outlookcode.com/d/sec.htm for your options with regard to the "object model guard" security in Outlook 2000 SP2 and later versions.


--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Tuck 'n Roll" wrote in message ...
Greetings all,
I have created a form in Access 2003 that uses Outlook 2003 to e-mail a
report to about 20 of my employees. It works fine with the exception that
it pauses and prompts me to click "Yes" or "No" for each recipient

 




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
outlook won't send multiple recipients (e.g., 5)--have OPMLog.log RichardConers Outlook - Installation 1 November 27th 06 04:28 PM
Multiple email recipients with Shared Fax Server on Server 2003/Exchange 2003 [email protected] Outlook - Fax Functions 2 October 10th 06 01:11 AM
send attachment to multiple recipients, but viewable only to one [email protected] Outlook - General Queries 2 May 10th 06 07:39 PM
tracking recipients of multiple mail merges [email protected] Outlook - Using Contacts 1 January 30th 06 12:05 AM
A program is trying to send mail using Item.Send Vitesh Outlook and VBA 1 January 23rd 06 03:25 PM


All times are GMT +1. The time now is 07:04 AM.


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.