Using SendObject in Access to send an email

Status
Not open for further replies.
R

RGFsZSBGeWU

I've got some code in Access an Access 2007 database that generates a series

of email messages to a bunch of customers.

Unfortunately, the security settings of Outlook popup a warning menu with

each email that is generated. As I recall, in Office 2003, when this

happened, the user was presented with an option to allow that functionality

for a period of time, so they did not have to repeatedly wait for the warning

message to finish processing and then click the Accept button. Is there a

way to do this in Access/Outlook 2007 as well?

--
HTH

Dale
 
A

Albert D. Kallal

I was under the impression that in 2007, this message is gone.

Try either ensuing that access is in a trusted location, or try setting

macro security to low....

I have access 2007, but only have outlook 2003....

Try either of the above ideas....I don't have the reference, but I do recall

reading somwhere that that nag prompt is gone in one of the above cases....

Albert D. Kallal (Access MVP)

Edmonton, Alberta Canada

pleaseNOOSpamKallal@msn.com
 
M

Mark Andrews

You could always go with a third party smtp component and avoid all these

issues.

Mark

RPT Software

http://www.rptsoftware.com

"Dale Fye" <dale.fye@nospam.com> wrote in message

news:FBD67EAC-DB60-4FF4-80C5-9D5319DBD317@microsoft.com...
> I've got some code in Access an Access 2007 database that generates a
> series
> of email messages to a bunch of customers.

> Unfortunately, the security settings of Outlook popup a warning menu with
> each email that is generated. As I recall, in Office 2003, when this
> happened, the user was presented with an option to allow that
> functionality
> for a period of time, so they did not have to repeatedly wait for the
> warning
> message to finish processing and then click the Accept button. Is there a
> way to do this in Access/Outlook 2007 as well?

> --> HTH
> Dale
>
 
K

Ken Slovak - [MVP - Outlook]

Low security isn't a good idea. However, in Outlook 2007 if you have an up

to date anti-virus program running the prompt won't occur in out of process

uses of the Outlook object model. SendObject() is a Simple MAPI call, not

Outlook object model. The results might be better if Outlook object model

code were used instead of a Simple MAPI call.

"Albert D. Kallal" <PleaseNOOOsPAMmkallal@msn.com> wrote in message

news:%23V2gX7rwJHA.5836@TK2MSFTNGP06.phx.gbl...
> I was under the impression that in 2007, this message is gone.

> Try either ensuing that access is in a trusted location, or try setting
> macro security to low....

> I have access 2007, but only have outlook 2003....

> Try either of the above ideas....I don't have the reference, but I do
> recall reading somwhere that that nag prompt is gone in one of the above
> cases....

> > Albert D. Kallal (Access MVP)
> Edmonton, Alberta Canada
> pleaseNOOSpamKallal@msn.com

>
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
T Outlook 2019 Using Gmail aliases in Outlook Using Outlook 6
M Saving emails using Visual Basic - Selecting folder with msoFileDialogFolderPicker Outlook VBA and Custom Forms 6
Z Import Tasks from Access Using VBA including User Defined Fields Outlook VBA and Custom Forms 0
justicefriends How to set a flag to follow up using VBA - for addressee in TO field Outlook VBA and Custom Forms 11
M Extract "Date sent" from emails (saved to folder using drag and drop) Outlook VBA and Custom Forms 1
I Outlook for Mac 2019 using on desktop and laptop IMAP on both need help with folders Using Outlook 1
David McKay VBA to manually forward using odd options Outlook VBA and Custom Forms 1
H Stationery using between OL 2019 and OL 2010 Using Outlook 0
P Prevent Outlook 2016 from using DASL filter Using Outlook 4
O Calendar - Location: what happens when using my own way of entering locations Using Outlook 1
M Disable Contact Card Results when using "Search People" in Outlook Ribbon Using Outlook 7
K can't get custom form to update multiple contacts using VBA Outlook VBA and Custom Forms 3
S Outlook VBA How to adapt this code for using in a different Mail Inbox Outlook VBA and Custom Forms 0
pcunite Outlook 2019/O365 Build 13127.20408 errors when using MAPI calls Using Outlook 1
B Change Font and Font size using VBA Outlook VBA and Custom Forms 9
M Outlook 2013 reminder email by using Outlook vba Outlook VBA and Custom Forms 2
X Using Outlook 2013 and Outlook 365 Using Outlook 1
A Going to folder using shortcuts Using Outlook 3
A Outlook replies not using "delivered to" address in From Using Outlook 1
Terry Sullivan E-Mails Sent Using a Group Box Result in 70 Kickbacks Using Outlook 4
O Email not leaving Outbox when using Excel VBA to sync Outlook account Outlook VBA and Custom Forms 4
K Using Outlook 2016 to draw Using Outlook 1
O Outlook 365 - suddenly unable to send using Gmail POP3 Using Outlook 10
N Disable Auto Read Receipts sent after using Advanced Find Using Outlook 4
G Outlook 2016 sync contacts directly between phone and computer using outlook 2016 Using Outlook 0
L Moving emails with similar subject and find the timings between the emails using outlook VBA macro Outlook VBA and Custom Forms 1
O Save attachments using hotkey without changing attributes Outlook VBA and Custom Forms 1
J Add an Attachment Using an Array and Match first 17 Letters to Matching Template .oft to Send eMail Outlook VBA and Custom Forms 2
A Edit subject - and change conversationTopic - using VBA and redemption Outlook VBA and Custom Forms 2
A Using or not using apostrophes in search terms has this changed? Using Outlook 0
O Office 365 using POP3 on both laptop and desktop Using Outlook 0
M Using field names to capture a data element Using Outlook 0
B Vba to monitor time to respond to emails using a shared mailbox Outlook VBA and Custom Forms 5
B Looking to get the Recipient email address (or even the "friendly name") from an email I am replying to using VBA Outlook VBA and Custom Forms 4
D Using a VBA Custom Form to Send Reoccurring Email Upon Task Completion Outlook VBA and Custom Forms 4
Z Adding dropdown list using custom form Outlook VBA and Custom Forms 7
O Using .OST and .PST mail thru different providers Using Outlook 5
N Open & Save VBAProject.Otm using VBA Code Outlook VBA and Custom Forms 1
D Remove text in subject using VBA Outlook VBA and Custom Forms 4
P How to export voting results using VBA? Outlook VBA and Custom Forms 2
E Using the Like operator properly Outlook VBA and Custom Forms 1
R Using "check for duplicates" for existing contacts Using Outlook 2
S Find a cell value in excel using outlook vba Using Outlook 1
N Using email notification to update calendar events? Outlook VBA and Custom Forms 4
S Macro using .SendUsingAccount only works the first time, after starting Outlook Outlook VBA and Custom Forms 4
C Sync Calendars using WiFI Using Outlook 3
A Capturing Send Variables without using Application_ItemSend in ThisOutlookSession Outlook VBA and Custom Forms 8
L Using alpha numeric in email address Using Outlook 5
Sabastian Samuel HOW DO I FORWARD AN EMAIL WITH MACRO using an email that in the body of another email Outlook VBA and Custom Forms 3
D create an html table in outlook custom form 2010 using vba in MsAccess Outlook VBA and Custom Forms 7

Similar threads

Top