+ Reply to Thread
Results 1 to 2 of 2

VBA Mass Email using Saved outlook item

  1. #1
    Forum Contributor
    Join Date
    07-17-2012
    Location
    India
    MS-Off Ver
    Excel 2016
    Posts
    715

    VBA Mass Email using Saved outlook item

    Hi Team

    Possible to have a macro which pick up the outlook item saved in desktop, add one additional attachment and email address from excel file and send it?

    I know of lot of codes in which entire email is prepared and added the attachment. But I never saw any codes in which outlook saved email can be used as base for macro?

    Kind Regards,
    Shiv
    Keep the Forum clean :


    1. Use [ code ] code tags [ /code ]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    2. Show appreciation to those who have helped you by clicking * Add Reputation below their posts.
    3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

  2. #2
    Forum Contributor
    Join Date
    07-17-2012
    Location
    India
    MS-Off Ver
    Excel 2016
    Posts
    715

    Re: VBA Mass Email using Saved outlook item

    Please Login or Register  to view this content.
    Okay, tried this code which seems could work. But now, why i am getting error msg as below.

    Attachment 798943

+ 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. [SOLVED] Problem with VBA code to attach file to email using a pre saved Outlook template
    By Wooltrain in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-12-2017, 08:28 PM
  2. VBA to perform mass email functions with Apple Mail (Macbook default email program)
    By thianphat in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-24-2014, 04:09 PM
  3. Adding attachments adds to an open outlook item and sends only blank email
    By Prabhucpk in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-14-2014, 04:13 PM
  4. [SOLVED] How to add an email attachement to VBA Mass Email by referencing file name in column
    By XCL88 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 04-10-2014, 06:20 AM
  5. Macro to send saved draft email from outlook in HTML format
    By jamesshakedown in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-18-2013, 07:55 AM
  6. [SOLVED] Help me fix attached code (create Outlook email then create calendar item)
    By Rerock in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-19-2013, 08:15 PM
  7. [SOLVED] Email addresses in Excel need to format for mass email
    By Boomer in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-09-2006, 08:50 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