Greetings I am New here (1 Viewer)

[pdesnoye]

Greetings

I am Patrick in Miami Florida. I have been experimenting with Access for a while and learned a lot through Youtube and this forum. I am working through a new application where I look to apply new things; such as sending emails from the applications directly and automatically.

I am exited to finally register to this forum and hope I will get better and find solutions faster.

I started this new application to email receipts to customers daily and realized that not everyone uses or have outlook on their computers. I thought cdo was the answer, but I get an error and can't find a solution for using gmail's smtp

 

[Jon]

Welcome to the forums! We are the most active Microsoft Access community on the internet by far, with posts going back over 20 years!

To get started, I highly recommend you read the post below. It contains important information for all new users to this forum.

https://www.access-programmers.co.uk/forums/threads/new-member-read-me-first.223250/

We look forward to having you around here, learning stuff and having fun!

 

[NauticalGent]

Welcome aboard!

 

[Uncle Gizmo]

I thought cdo was the answer, but I get an error and can't find a solution for using gmail's smtp

This is old info, but it may help:-

Gmail from MS Access, VBA, Excel, Word… - Nifty Access

Gmail from MS Access, VBA, Excel, Word… "Send a Secret Email" Escape From Outlook Video 1 (0:56) Escape From OutlookMicrosoft tightly combine their applications together however sometimes it’s nice to escape from Microsoft Products and use others. Here I demonstrate how you can use Google Mail...

www.niftyaccess.com

 

[theDBguy]

Hi. Welcome to AWF!

 

[The_Doc_Man]

Hello, Patrick, and welcome to the forum.

If your problem is sending e-mail, it is possible to use something called CDO to send mail without a specific mail utility (like Outlook) on your system. You DO need to have a target SMTP server on your network, but the client machines can be plain-old Windows boxes.

 

[pdesnoye]

Hello, Patrick, and welcome to the forum.

If your problem is sending e-mail, it is possible to use something called CDO to send mail without a specific mail utility (like Outlook) on your system. You DO need to have a target SMTP server on your network, but the client machines can be plain-old Windows boxes.

Thank you. I have been trying the cdo option. I think I finally got it to send the email.
I will probably ask help to set it up in a more secure way. I am not sure I understand the Password APP option of gmail

 

[The_Doc_Man]

CDO is a good product but I never used it with a password option so won't be able to get that specific. Then again, our e-mail gateway didn't care about passwords anyway. It was an intranet system from our viewpoint, so we had to already be logged in on the network to get to it in the first place.