How to Send Email from Microsoft Access using Microsoft Outlook and Bypass the Security Warning

[@tomtripicchio3412]

Hi Richard, this video is exactly what I was looking for, thank you. What I am interested is the extended cut of this video. I need to email to each person their monthly report, currently 160 different people. Please tell me what I can do to just get this module or my choices. Thanks.

[@monicak.2109]

Can you help. When I type .Body or ."anything" I dont get the options like you do but when I type "=" after it I do get the options after Me.xxxx. What am I missing to get the options when start writing after With......

[@599CD]

599cd.com/ask

[@hggryrdchgc]

is there a way i can learn this without paying $260?

[@fgh-aj]

Hi Richard! Excellent tutorials you have! I have one question about this tutorial. Why when sending email the email is not sent until outlook application is open. To simplify i send the email to my second email address and nothing happens i don't get the email.Then i have to open outlook app to get the email i have sent. Any solution? Thanks in advance.

[@599CD]

599cd.com/Ask

[@amradel3680]

Hi Richard, I want to send emails from MS access, exporting queries as excel files and then send it by email (Outlook) with this excel file attached to the email. I also want the "From" and "To" fields to read the email addressed from a table. Can you please help.

[@599CD]

I've got a whole seminar on all the different ways to send email 599cd.com/EmailSeminar

[@599CD]

If you've got other specific questions post them in the Forum on my website since you remember and will help you out there. I spend very little time answering questions on KZbin sorry.

[@annawenlock8861]

This works great, but is there a way to make it open the email (and still format it using HTML) using the online version of outlook (outlook 365) as this is what my team prefers?

[@599CD]

As far as I'm aware of... no.

[@599CD]

However if that's the case you can use the techniques that I show in my Email Seminar to send the mail using any SMTP server. 599cd.com/EmailSeminar

[@davidallen4603]

Hi Richard, love this and have the code working, however, it would be great to be able to include my OL signature. Is there any possibility you could do an update to this video showing how to do this please?

[@599CD]

Easier to include it in your email text.

[@brettallain8549]

Your video was exactly what I was looking for, simple vba code to send email. I’ve tried to add the outlook signature using vba code but I’ve been unsuccessful, could you please help ?

[@599CD]

Feel free to submit your question at 599cd.com/TH

[@jimmatthews6657]

Excellent Video - this resolved almost everything I wanted/needed to do except one. Perhaps you can point me in the right direction for this last item. The last hurdle I need to get over is the sender name. The emails I sent need to originate from an email address other than the email I'm using to sign into Outlook. The sender email is a secondary group email which I can choose while creating an email in Outlook. I just can't figure out how to select it using Access VBA. Thanks in advance.

[@jennifermiller7783]

A little late to the party. Got this to work for everything except the .To statement. Referencing a field but it isn't working. Any ideas of things I can look for. Thank you for the directions!

[@GregandJoanKoskela]

Your videos have become my first choice when needing to learn new things in Access! Do you have a video on sending an appointment via Access? We schedule trainings with over 100 people and would like to send appointments with their training details to each one instead of a list to everyone and then they have to add to their calendar.

[@gregenglish7241]

Your training videos are a great help. I have been trying to use your exampole but cannot get the new line formula to work any suggestions?

[@miked5483]

could this work with mozilla thunderbird or windows mail app?

[@PaulAponte-k4x]

This seems to have stopped working in 2024.

[@599CD]

Still works for me.

[@Silentbutdeadly5566]

@@599CDlove your response 😂

[@luyonjostephen8746]

Hi Richard, My laptop has windows defender firewall and it doesn't have a option for updating... I don't know if they are one and the same but sending mails still return the error window. What's your say on this?

[@599CD]

I've never seen Defender that couldn't be updated.

[@Adorable.Princess]

Can we format the text ? Like to make some words bold ? How can we make some words in bold ?

[@599CD]

You can use HTML text, yes. I cover that in 599cd.com/EmailSeminar

[@user-oj3lt1nt8v]

Hi Richard, thank you so much for the video! I have a small problem, after I copied all the lines the VBO doesn't seem to recognise the email adress field. The adress field is left empty. I checked the spelling a zillion times, he doesn't recognise any fields: (name, email, etc) Would you be so kind to help me out?

[@user-oj3lt1nt8v]

Never mind, I figured it out!

[@599CD]

Glad I could help. :P

[@julianbromelow2954]

Hi Richard, I need to export a report as pdf and attach to an email which I can do with the sendobject action, but I also need to attach another pdf (saved on my pc) in this case Terms and Conditions. I cant do this using the sendobject action. Can it be done? If I need to Join and view a lesson/seminar then please let me know which one. Happy to join if you have the solution! Thanks!

[@599CD]

I cover multiple attachments in 599cd.com/EmailSeminar

[@alirizvi748]

Great Video Sir!! Just one QUESTION: Can we put a FROM email address in the code? How can I send email from added email account in Outlook? If you can answer this, it will be appreciated!

[@599CD]

599cd.com/EmailSeminar

[@anikajames7754]

Hi Rick. How can i send emails from microsoft access using gmail. I dont have outlook. Please help

[@599CD]

I cover that in my Email Seminar: 599cd.com/EmailSeminar

[@anjaliangel2045]

best template. you are a great man sir! respect

[@599CD]

Thanks a lot!

[@samuelforrest2698]

Hey Richard, great videos. Thank you, my access won't pre populate the email, any ideas?

[@599CD]

I haven't come across that issue before. Without being able to see your system, it's very hard to diagnose. See 599cd.com/Trouble

[@opencarrymagazine5134]

How do I send email from access using thunderbird

[@599CD]

Never used Thunderbird, although in my Email Seminar I show you how to send using ANY SMTP server (email program independent). 599cd.com/EmailSeminar

[@chansaemmanuelkatongo3817]

How can I join the seminar so that I can learn how to send bulk emails with individualized attachments (invoices) to individuals.

[@chansaemmanuelkatongo3817]

I didn't see the "Join" button for me to join your group. Thank you for your nice video on how to send emails from ms access.

[@599CD]

If you don't see a JOIN button under the video, it may not be available in your country on KZbin. You'll have to join on my site directly: 599cd.com/Join

[@bondniko]

Should work with late binding without reference to the outlook library.

[@599CD]

You are indeed correct. Figured it's easier to explain with the reference.

[@RakeshSharma-cx5uh]

Can we work on Power BI with the database we make on Access? With continuous data received.

[@599CD]

Sure.

[@johndavy3820]

Hi Rick, Is there a Template for Send Outlook Email? Thanks John

[@599CD]

Yep. 599cd.com/SendOutlookEmail

[@mehdibob5340]

I nedd to add an attachment, can you help me ?

[@599CD]

Sure... 599cd.com/EmailSeminar

[@kagnes22]

Hi Richard! Excellent tutorials you have! I have learned a lot form you. I'm grateful. With email sending, I have some problem, though. I strictly followed your steps in the video, and it nevertheless indicates an error in this line "Set O = New Outlook.Application". What might be the reason? Thank you for your answer in advance.

[@599CD]

Did you add the reference?

[@kagnes22]

@@599CD Thank you for your answer. I did. I strictly followed what you showed.

[@kagnes22]

Hi Richard, I have found the solution for my former problem. It might be useful for others as well. It is that before you push on the Email button, you should close Outlook, then it works like clockwork. :-)

[@adamw568]

Is it possibile to use Outlook templates in above solutions?

[@599CD]

Not sure. Never tried. But why bother? You can customize everything right in Access and just use Outlook to send the email.

[@tpointsystems621]

Excellent video will definitely follow and subscribe

[@599CD]

Thanks and welcome

[@sabeensadaf1795]

How do i add mutiple cc’s?

[@599CD]

You'll need something like a recordset loop.

[@jungjungdelosreyes4147]

Nice sir Richard, can you help a sample also how to put a linked inside the email?

[@599CD]

A linked... what?

[@jungjungdelosreyes4147]

@@599CD thank you so much for your reply. I’m so happy for your response. Sir, i meant a linked to be appeared in the body of the email, thats lead to open a folder where they can copy all the bunch of documents files.

[@stelioschristofis9931]

@@599CD LOL

[@stelioschristofis9931]

@@599CD A L I N K E D

[@HeyTezza]

You are awesome thank you 👏

[@599CD]

Welcome!