Thanks for taking the time to do these videos! I find them very useful and informative.
@DanielPineault2 жыл бұрын
Glad you like them! Thank you for the feedback.
@lorenzogaruglieri70462 жыл бұрын
@@DanielPineault now subtitles works.
@lorenzogaruglieri70462 жыл бұрын
Hi Daniel, can you please turn on automatic subtitles for this video? Your videos are fundamental!! Thank you
@DanielPineault2 жыл бұрын
I'm new to KZbin, let me see what I can do. And thank you for the Feedback.
@DanielPineault2 жыл бұрын
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.
@lorenzogaruglieri70462 жыл бұрын
@@DanielPineault thanks Daniel.
@LearnAccessByCrystal2 жыл бұрын
@@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.
@LearnAccessByCrystal2 жыл бұрын
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.
@LearnAccessByCrystal2 жыл бұрын
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
@DanielPineault2 жыл бұрын
Thanks for the tips, I never use captions so I never noticed. Something to improve upon in future videos!
@LearnAccessByCrystal2 жыл бұрын
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.
@rodgp9 ай бұрын
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
@DanielPineault9 ай бұрын
Going by memory, I believe there's a registry hack to enable TLS 1.2 I believe and then it worked for me.
@rodgp9 ай бұрын
@@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!