![]() |
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. |
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
![]()
I have been sending Excel work books to outlook mail recepients using VBA.
The code is written in the Excel VBA Editor as follows: Dim oMSOutlook As Object Dim oEmail As Object Set oMSOutlook = CreateObject("Outlook.Application") Set oEmail = oMSOutlook.CreateItem(olMailItem) With oEmail .Attachments.Add (ActiveWorkbook.FullName) .To = " .Send End With Question: When I run the following code outlook generate a message saying " A programm is trying to send mails automatically . Do you want to allow this?" How to avoid this message. since there are more than 50 mails and have to press "Yes" for all these mails. pls help - Zulfi |
#2
|
|||
|
|||
![]()
See http://www.outlookcode.com/d/sec.htm for your options.
-- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003 Reminder Manager, Extended Reminders, Attachment Options http://www.slovaktech.com/products.htm "zulfi" wrote in message ... I have been sending Excel work books to outlook mail recepients using VBA. The code is written in the Excel VBA Editor as follows: Dim oMSOutlook As Object Dim oEmail As Object Set oMSOutlook = CreateObject("Outlook.Application") Set oEmail = oMSOutlook.CreateItem(olMailItem) With oEmail .Attachments.Add (ActiveWorkbook.FullName) .To = " .Send End With Question: When I run the following code outlook generate a message saying " A programm is trying to send mails automatically . Do you want to allow this?" How to avoid this message. since there are more than 50 mails and have to press "Yes" for all these mails. pls help - Zulfi |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Warning Messag | srcbutterfly | Outlook - Using Contacts | 2 | November 15th 06 08:12 PM |
Sending an alert (email or sms) when adding/scheduling an appointment | [email protected] | Outlook - Calandaring | 3 | September 13th 06 04:26 PM |
Exporting e-dresses from contacts 2 Excel: how avoid SMTP suffix? | John | Outlook - Using Contacts | 5 | July 12th 06 09:21 PM |
Avoid duplication when sending to multiple groups | pwrichcreek | Outlook Express | 3 | January 22nd 06 05:11 PM |