Hi. I have a VBA that mails portion of a worksheet as PDF. The problem is that the process is not really automated as I have to open Outlook manually to allow the emails to send.
I learnt there's a way emails can be sent using CDO. Can someone help me out?
I use VBA to send mail using Outlook without having to open Outlook manually. The code should create an instance of Outlook, then take it down when done. However, if you insist on using CDO instead then this explanation should be helpful.
You are asking a generic question. You can get advice specific to your problem if you attach your file or at least show your current code.
@ 6StringJazzer
Here is my code:
Please Login or Register to view this content.
Have you checked out Ron de Bruin's excellent web site that deals with this?
https://www.rondebruin.nl/win/s1/cdo.htm
That handles sending a specific range in an email which is what your OP requested.
There are other versions if you wish to attach a file/workbook and send by email.
Last edited by Richard Buttrey; 07-15-2018 at 11:08 AM.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks