Hi all, so I want to create a macro that could draft an email, but not immediately sending it because I want to do a one last checking before sending.
So I created 3 sheets in the file I've attached:
1. Setup -> This is to setup the date and month that's written in the email, it's editable. Basically the Setup sheet is to cross-check if the day the email sent is not on either Saturday/Sunday. I've created a little button to check, so there's no issue there.
2. Heading -> This is to insert Subject and put the list of To and Cc the people to send the emails to
3. Email Content -> The content I want on the emails that I'd send
I'm confused to create a macro that could:
1. Input the Subject, To and Cc
2. Everything written in Sheet "Email Content" is what I want in the email. The contents in that sheet is changeable. In the sample email I have a 8-row table, but it can also be a 2-row table and others
3. Not immediately sending, just draft first so I can check if the contents are already good to go
Can anyone help me on this? I've attached the sample file that I've created with all the sheets.
Oh yeah, as a note, I use Ms. Outlook.
Thank you so much in advance!![]()
Bookmarks