+ Reply to Thread
Results 1 to 3 of 3

Macro to send worksheets as single attachment and send mail

  1. #1
    Registered User
    Join Date
    03-10-2014
    Location
    Chennai
    MS-Off Ver
    Excel 2010
    Posts
    14

    Macro to send worksheets as single attachment and send mail

    Hi team need a help again.

    I have a workbook with some 50 worksheets. each sheet has different name and there is a master sheet where the names are in a column and also the mail id against each sheet name.

    Currently need a macro, where each worksheet is copied and pasted in a new workbook with shee tname as workbook name and send a mail with the workbook attached

    request your help here.

    Thanks in advance.

    Regards,
    Naveen

  2. #2
    Registered User
    Join Date
    03-10-2014
    Location
    Chennai
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: Macro to send worksheets as single attachment and send mail

    Hi TEam, Please help as i am unable to get thro

  3. #3
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    8,160

    Re: Macro to send worksheets as single attachment and send mail

    I have a workbook with some 50 worksheets. each sheet has different name and there is a master sheet where the names are in a column and also the mail id against each sheet name.
    Mind readers we are not...We have no clue of what your setup is...So how are we able to assist...

    See Top Yellow Banner

    Also...Doesn't really seem you follow through with your posts as seen here...So why should we try and assist...
    https://www.excelforum.com/excel-pro...-workbook.html
    https://www.excelforum.com/excel-pro...l-value-2.html
    Last edited by sintek; 05-22-2020 at 04:00 AM.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere.....
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember......Mark Thread as Solved.
    Excel Forum Rocks!!!

+ 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. Send e-mail with attachment
    By alexduy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-03-2016, 02:05 AM
  2. Replies: 1
    Last Post: 03-11-2014, 12:24 PM
  3. [SOLVED] Auto send mail with attachment
    By mukeshbaviskar in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-13-2013, 09:38 AM
  4. Excel send e-mail with two attachment
    By rbbahia in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-10-2013, 03:27 PM
  5. Code to send an e-mail. Don't send if attachment not found
    By thedon_1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-24-2012, 05:41 PM
  6. [SOLVED] Send E-Mail with Attachment
    By Vladamir in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-11-2012, 02:52 PM
  7. [SOLVED] send to mail recipient as attachment - no worky...
    By Scott McDonald in forum Excel General
    Replies: 0
    Last Post: 04-22-2005, 09:08 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