+ Reply to Thread
Results 1 to 3 of 3

VBA code to send excel attachment through outlook 2010

  1. #1
    Registered User
    Join Date
    12-19-2013
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    53

    VBA code to send excel attachment through outlook 2010

    Hello Friends,

    Is it possible to send 100 diffrent excel file through outlook 2010 to diffrent recipient with same subject and same email body through VBA?

    Please help to know this.

    Thanks,
    Liz.
    Last edited by Liz_Biz; 04-04-2014 at 08:33 AM.

  2. #2
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: VBA code to send excel attachment through outlook 2010

    Have a look here: http://www.rondebruin.nl/win/s1/outlook/amail6.htm
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  3. #3
    Registered User
    Join Date
    12-19-2013
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    53

    Re: VBA code to send excel attachment through outlook 2010

    Problem Solved..Thanks Olly. I appreciate your help.

+ 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] Macro to send a pdf attachment via outlook from excel
    By Josiah in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-26-2013, 02:17 PM
  2. code to attach the draft mail in new compose mail as attachment in outlook 2010
    By priya1987 in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 10-10-2012, 08:38 AM
  3. Excel to send email via Outlook (attachment)
    By uncleslinky in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-01-2012, 07:01 AM
  4. Send sheet as Outlook attachment
    By Jessy01 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-04-2011, 01:28 PM
  5. Send Excel attachment, but wait till Outlook closes
    By thepython in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-17-2006, 05:30 PM

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