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.

    Regards,
    Prabhu
    Attached Files Attached Files

  2. #2
    Magician NoS's Avatar
    Join Date
    Jan 2013
    Location
    British Columbia
    Posts
    675
    Articles
    0
    Excel Version
    Excel 2010 64bit
    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,

    Prabhu

Posting Permissions

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