VBA - Sending Emails

[@SHCSBaker]

Thanks for taking the time to do these videos! I find them very useful and informative.

[@DanielPineault]

Glad you like them! Thank you for the feedback.

[@lorenzogaruglieri7046]

@@DanielPineault now subtitles works.

[@lorenzogaruglieri7046]

Hi Daniel, can you please turn on automatic subtitles for this video? Your videos are fundamental!! Thank you

[@DanielPineault]

I'm new to KZbin, let me see what I can do. And thank you for the Feedback.

[@DanielPineault]

After checking, KZbin automatically generates them, but there can be a delay as is the case with this video. I'll have to investigate creating and uploading my own for future videos.

[@lorenzogaruglieri7046]

@@DanielPineault thanks Daniel.

[@LearnAccessByCrystal]

​@@DanielPineault yes, there is a delay for KZbin to transcribe your video from a couple to several hours, maybe even half a day. What you can do is upload the video and mark it either Private or Unlisted. then once the automatically generated captions are done, make it public. Alternately, if you write a script, like I do, I made an Access database to read the script. then I watch the video and click each caption as it is spoken to time-code it. Then Access makes the caption file you can upload to KZbin. If you want the database, I'll share it with you -- email me.

[@LearnAccessByCrystal]

ps, Daniel, my program can also read a transcript with time codes -- although I find it better to copy transcript without time-codes, correct the text (if you want to go that far since technical terms don't get done well nor do lines break in logical places), use Access to time-code it again, and generate SRT file with captions. Nice that KZbin lets you change captions anytime without having to re-upload the video, as the caption file is a separate thing. You can also translate captions and upload caption files in other languages.

[@LearnAccessByCrystal]

Daniel, excellent! Very thorough. You're a great teacher. interesting about SendObject ... the macro action is a combo box, so you can actually type SendObject and Access will correct to EMailDatabaseObject -- so this is a good way to find out what actions have been renamed to ;) btw, to separate multiple recipients, did you mean to say semi-colon not colon? (Maybe it's different in Canada?) I couldn't read what you typed. I love that you covered TBird! Do you know what the connect string is to link to mailboxes? Or maybe you can do a video about that? fyi, captions will cover the bottom couple lines on the screen, so keep in mind when recording (smile). At 27:17, SendHTMLEmail is at the bottom but to read it, captions can't be on (or need to be positioned somewhere else), and happens in other places too. thanks, Daniel

[@DanielPineault]

Thanks for the tips, I never use captions so I never noticed. Something to improve upon in future videos!

[@LearnAccessByCrystal]

You're welcome @@DanielPineault btw, KZbin only does transcriptions if the language is specified, which obviously you've done!

[@jerrydfowler3480]

Great video and theres alot of info. I primarily use GMail as my email. Is that possible with Access?

[@DanielPineault]

Sure. You can stop Outlook to that account and then SendObject and Outlook automation will both work. You could also use CDO mail directly. The choice is yours.

[@rodgp]

HI, thanks for the tutorial. Did you find a way to have CDO mail sent using TLS & port 587 ? When I enter the parameters is says STARTTLS is required to send mail and I read on the internet that it's a CDO librairy issue Thanks

[@DanielPineault]

Going by memory, I believe there's a registry hack to enable TLS 1.2 I believe and then it worked for me.

[@rodgp]

@@DanielPineault I finally decided to use Powershell to send using port 587 and looked at your video about using PS commands in VBA, I could not have my CDOMail commands to work using PS one through VBA although my code works in PS without the queries to list my receivers and attachments. If you ever make a video for this, I'd surely be interested !

[@jimstockman926]

I like the simplicity of doCmd.SendObject, but it fails if Outlook is open - runtime error 2293. If I close Outlook, it runs as expected. I already deploy Outlook automation so I have a working system, but I'm curious if there is a way to overcome the issue Access has with Outlook being open when the doCmd.SendObject is called?

[@DanielPineault]

I've never experienced that issue, but you could check if the process is running and close it first if required. You could also try using GetObject and if it works then you need to close the instance.

[@DanielPineault]

Also, sendobject uses the default account. Do you have multiple accounts setup in Outlook by any chance. Just curious if that could be the issue.

[@jimstockman926]

@@DanielPineault - Nice catch - I do have multiple accounts setup in Outlook. Will have to do some tinkering to see how that plays into it. Thanks for the response!