By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,640 Members | 2,279 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,640 IT Pros & Developers. It's quick & easy.

Email with CC/ and Subject Line

P: 16
Hello All,

I am VBA newbie, I only use basic/easy codes to make my databases run more efficiently, I depend mostly on Macros.

Can anyone help with a basic code to add a "CC" and "Subject" line to an outlook email populated from a command button?

I'm using the below code and it works, but I want to add a CC email address and an automatic subject.

Expand|Select|Wrap|Line Numbers
  1. Private Sub SELECT_DblClick(Cancel As Integer)
  2. FollowHyperlink "mailto: EMAIL ADDRESS"
  3. End Sub
Thanks in Advance
Feb 6 '12 #1
Share this Question
Share on Google+
2 Replies

Expert 5K+
P: 8,638
To the best of my knowledge, in order to send an E-Mail along with a single, or multiple, CC Recipients requires Outlook Automation Code. I'll be more than happy to show you, but it is beyond 'basic/easy codes'. Just let us know one way or another.
Feb 6 '12 #2

P: 16
@ADezii I totally cheated, I used the Hyperlink Control and put all the email addresses on one line (Forget CC), inserted the subject verbiage and formatted the link to look like my command buttons.

It works!

Thanks for your willingness to help!
Feb 6 '12 #3

Post your reply

Sign in to post your reply or Sign up for a free account.