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.
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.
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.
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!
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?
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.
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 ?
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!
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?
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 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.
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.
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 UA-cam sorry.
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?
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!
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.
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. :-)
I am using windows 11. I have installed outlook. I wrote the code as instructed. But when I tried it, the outlook mail window did not appear and Microsoft Access was halted.
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?
If you don't see a JOIN button under the video, it may not be available in your country on UA-cam. You'll have to join on my site directly: 599cd.com/Join
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.
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.
best template. you are a great man sir! respect
Thanks a lot!
Excellent video will definitely follow and subscribe
Thanks and welcome
So far so good... I've subscribed to silver but can't see the extended cut. Where do I look please?
Look in the description text below the video window.
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?
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.
You are awesome thank you 👏
Welcome!
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!
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?
Easier to include it in your email text.
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.com/Ask
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 ?
Feel free to submit your question at 599cd.com/TH
could this work with mozilla thunderbird or windows mail app?
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.com/EmailSeminar
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?
I've never seen Defender that couldn't be updated.
Hey Richard, great videos. Thank you, my access won't pre populate the email, any ideas?
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
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.com/ask
Nice sir Richard, can you help a sample also how to put a linked inside the email?
A linked... what?
@@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.
@@599CD LOL
@@599CD A L I N K E D
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.
I've got a whole seminar on all the different ways to send email 599cd.com/EmailSeminar
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 UA-cam sorry.
Is it possibile to use Outlook templates in above solutions?
Not sure. Never tried. But why bother? You can customize everything right in Access and just use Outlook to send the email.
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?
Never mind, I figured it out!
Glad I could help. :P
Can we format the text ? Like to make some words bold ? How can we make some words in bold ?
You can use HTML text, yes. I cover that in 599cd.com/EmailSeminar
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!
I cover multiple attachments in 599cd.com/EmailSeminar
Should work with late binding without reference to the outlook library.
You are indeed correct. Figured it's easier to explain with the reference.
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.
Did you add the reference?
@@599CD Thank you for your answer. I did. I strictly followed what you showed.
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. :-)
Can we work on Power BI with the database we make on Access? With continuous data received.
Sure.
I am using windows 11. I have installed outlook. I wrote the code as instructed. But when I tried it, the outlook mail window did not appear and Microsoft Access was halted.
I suspect you're using the "New" Outlook. See: 599cd.com/NewOutlookNotReady
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?
As far as I'm aware of... no.
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
How can I join the seminar so that I can learn how to send bulk emails with individualized attachments (invoices) to individuals.
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.
If you don't see a JOIN button under the video, it may not be available in your country on UA-cam. You'll have to join on my site directly: 599cd.com/Join
Hi Rick, Is there a Template for Send Outlook Email? Thanks John
Yep. 599cd.com/SendOutlookEmail
How do i add mutiple cc’s?
You'll need something like a recordset loop.
I nedd to add an attachment, can you help me ?
Sure... 599cd.com/EmailSeminar
Hi Rick.
How can i send emails from microsoft access using gmail. I dont have outlook.
Please help
I cover that in my Email Seminar: 599cd.com/EmailSeminar
is there a way i can learn this without paying $260?
How do I send email from access using thunderbird
Never used Thunderbird, although in my Email Seminar I show you how to send using ANY SMTP server (email program independent). 599cd.com/EmailSeminar
This seems to have stopped working in 2024.
Still works for me.
@@599CDlove your response 😂