+ Reply to Thread
Results 1 to 6 of 6

Excel VBA Outlook needing to add to and CC to outlook emails

  1. #1
    Registered User
    Join Date
    06-23-2017
    Location
    Florida
    MS-Off Ver
    2013
    Posts
    4

    Excel VBA Outlook needing to add to and CC to outlook emails

    Hi, I have the below code and it works perfectly but now i need to add a column of email addresses and make it show up in the CC section of the outlook email. I'm not sure what I'm doing wrong but i have tried this multiple times but with no success.

    how the code currently works: i put in my email addresses in column B and it creates a preformatted email automatically.

    I need it to still pull the email addresses from column but i need it pull from column C and add those emails in the CC section of the email
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by Leith Ross; 08-28-2018 at 01:21 PM. Reason: Added Code Tags

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    re: Excel VBA Outlook needing to add to and CC to outlook emails

    Try this...

    Please Login or Register  to view this content.
    Last edited by AlphaFrog; 06-23-2017 at 04:14 PM.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Registered User
    Join Date
    06-23-2017
    Location
    Florida
    MS-Off Ver
    2013
    Posts
    4

    re: Excel VBA Outlook needing to add to and CC to outlook emails

    I have tried the suggested code and it works beautifully. Thank you so much, I will need to study this code and use for a reference.

  4. #4
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    re: Excel VBA Outlook needing to add to and CC to outlook emails

    You're welcome.

    This line is incorrect
    Please Login or Register  to view this content.
    It should be
    Please Login or Register  to view this content.
    I edited the code in post #2.

  5. #5
    Registered User
    Join Date
    06-23-2017
    Location
    Florida
    MS-Off Ver
    2013
    Posts
    4

    re: Excel VBA Outlook needing to add to and CC to outlook emails

    Alphafrog

    is there way to add an outlook task or calendar appointment to the code?

  6. #6
    Registered User
    Join Date
    06-23-2017
    Location
    Florida
    MS-Off Ver
    2013
    Posts
    4

    re: Excel VBA Outlook needing to add to and CC to outlook emails

    is there a way to attach more than one file to this code?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Search Outlook Emails From Excel
    By Jimhol in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-23-2017, 03:10 PM
  2. Outlook VBA needed for Counting emails in outlook by specific date
    By Marijke in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 07-12-2017, 10:12 AM
  3. Outlook 2010, send all emails from outlook outbox
    By joao1232 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-22-2016, 07:33 PM
  4. Track Outlook Emails - sent emails in Excel
    By baluraipur in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-06-2015, 09:18 AM
  5. MS Outlook Emails from Excel using VBA
    By Dbomber in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-06-2013, 02:23 AM
  6. Sending Outlook Emails from/using Excel VBA - Outlook and Excel
    By dluhut in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-19-2013, 11:32 AM
  7. [SOLVED] Sending Outlook emails from Excel; Limits to three emails only?
    By BPSJACK in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-29-2013, 06:53 AM

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