Results 1 to 3 of 3

Thread: Attach Excel and Send Mail

  1. #1

    Attach Excel and Send Mail

    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi Friends,

    I have attached a workbook which has many sheet.

    My existing macro work if the specified sheet in the Marco exist in the workbook.

    suppose if it is not in the workbook then macro gets stooped.

    kindly help to modify even if any of the sheet specified in the macro not exist then it should work with the existing sheet.

    Attached Files Attached Files

  2. #2
    Magician NoS's Avatar
    Join Date
    Jan 2013
    British Columbia
    Excel Version
    Excel 2010
    Added a function to your module and used it to check if sheets exist. Commented out some unnecessary lines. You'll need to tidy it up.

    Hope this helps.
    Attached Files Attached Files

  3. #3
    Hi Friend,

    Thank you! it is working great!

    i have one more request,i added the same sheet with fruit names.

    while i attach sheet 'banana' in a mail, sheet 'apple' to be pasted in the body of the same mail.

    similarly if i attach 'orange' and 'grape' sheet 'jack' to be pasted in the body of the same mail.

    is this possible?

    Thanks & Regards,


Posting Permissions

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