• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Save as a new workbook and email the attachment under conditions


New Member
Dear Team,
Selected data range of source file to be copies into a new workbook and same to be email to a predefined group with below conditions.
Clicking the button " Email excel file" on source excel file, following steps to be done
Open a new excel file in "E:\New Excel Formats_Formula & Macro\New TRF_2021\" & save name as the value in cell "AT2" (AT2 value is changing as per current time)
Copy the range A:AM of this file and paste the content into the above said excel work book with all the formats except formula
Attach the newly created work book in to a new Microsoft outlook email
Email To: abc@example.com
CC : cxyz@example.com; efg@example.com; ghi@example.com
Subject : Value in cell "AT2"
Body : Dear,
Herewith enclosed the TRF for style# (Value in cell "H11)
Signature (Existing active signature in outlook)
Text format : Existing active text format in outlook

Thank you in advance.
Best Rgds,
Nuwan Buddhika.