+ Reply to Thread
Results 1 to 6 of 6

Adding an additional CC to automated email from Excel

  1. #1
    Registered User
    Join Date
    09-19-2012
    Location
    manchester
    MS-Off Ver
    Excel 2010
    Posts
    2

    Adding an additional CC to automated email from Excel

    Hi,

    I need to add a few more people to my distribution list of an automated report that is issued each morning, how do i add this in ? Help.... the code i currently have is below

    Please Login or Register  to view this content.

    Thanks in advance for any help

    Paul
    Last edited by arlu1201; 09-19-2012 at 09:49 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    05-08-2012
    Location
    Georgia, USA
    MS-Off Ver
    Excel 2003, 2010
    Posts
    811

    Re: Adding an additional CC to automated email from Excel

    Read Forum Rules:
    Code needs to be within code tags
    Click on star (*) below if this helps

  3. #3
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Adding an additional CC to automated email from Excel

    Thanks Km.

    Pauliandavies,

    Welcome to the forum.

    I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature below this post.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  4. #4
    Registered User
    Join Date
    09-19-2012
    Location
    Edinburgh, Scotland
    MS-Off Ver
    2007
    Posts
    10

    Re: Adding an additional CC to automated email from Excel

    Hi Paul,

    Separate each email address with a semicolon, all within one set of quotes.

    e.g.
    Please Login or Register  to view this content.
    Works for To and BCC as well.

    Bill

  5. #5
    Registered User
    Join Date
    09-19-2012
    Location
    manchester
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Adding an additional CC to automated email from Excel

    brilliant, nice and simple and should have really guessed at that. Thanks for your help

    Paul

  6. #6
    Registered User
    Join Date
    09-19-2012
    Location
    Edinburgh, Scotland
    MS-Off Ver
    2007
    Posts
    10

    Re: Adding an additional CC to automated email from Excel

    No probs.

    Don't forget to mark the problem as 'solved'. There should be something to do that in one of the dropdowns at the top.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1