Bulk Email Sending with an attachment via Gmail Account

[Priyantha]

Dear All,

I intend to send payslips to around 500 people (with an attachment) through a Gmail Account. While searching for that I found the attached macro.

01). If there are other suitable methods (Eg. with Google Drive or Google Script) for this process, please explain such a suitable method to me.

02). If there is no other way, please explain to me the necessary codes for the changes to be made in this macro (for speeding up, etc.).

03). Also, if it is possible to block my email address while sending Bulk Emails through this macro or any other method I will kindly ask you to advise me on the steps to be taken to prevent it.

Please advise me above issues.

Thanks.

Regarding,

Priyantha.