Email with CC/ and Subject Line

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Cabnabs
    New Member
    • Nov 2011
    • 16

    Email with CC/ and Subject Line

    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.

    Code:
    Private Sub SELECT_DblClick(Cancel As Integer)
    FollowHyperlink "mailto: EMAIL ADDRESS"
    End Sub
    Thanks in Advance
    Last edited by NeoPa; Feb 7 '12, 03:37 AM. Reason: Added mandatory [CODE] tags for you
  • ADezii
    Recognized Expert Expert
    • Apr 2006
    • 8834

    #2
    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.

    Comment

    • Cabnabs
      New Member
      • Nov 2011
      • 16

      #3
      @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!

      Comment

      Working...