Send Workbook as an Attachment Via Gmail - Code Review

[psanghvi]

Hello,

Below is a code for sending workbook as an attachment. The below works fine but its not sending the workbook as an attachment. I get the email based on the parameters below, but its only the strbody message that comes through and nothing from the workbook. I would like the entire workbook (has only one worksheet) to come through as an attachment.

And at the end of the loop, the workbook should save itself on the local desktop with filename&"_"&date (date mentioned in cell f1) and close.

Please Login or Register  to view this content.