I am new in VBA and will like consult help to create a excel VBA which can email a list of persons. Does anyone has a template you can share or provide me with the code? Thanks so much in advance.
[FONT="]General outline: To generate emails to a list of recipients in the excel
1) Sheet 1 will contain all the email addresses
2) Sheet 2 will have the outlook appearance.
To:
CC:
BCC:
Email subject title:
Email Body:
"From cell AX to GX" (Give me a empty cell to change the value of "G"; email body should allow me to insert formulae)
Signature:
3) by the click of a macro button, it generates the Outlook emails. Give me an empty cell to determine whether to send out emails automatically or generate but do not send out for my verifications.[/FONT]<img style="box-sizing: border-box; vertical-align: middle; border: 0px; color: rgb(73, 73, 73); font-family: "Gotham SSm", Helvetica, Arial, sans-serif; background-color: rgb(250, 250, 250);">
[FONT="]General outline: To generate emails to a list of recipients in the excel
1) Sheet 1 will contain all the email addresses
2) Sheet 2 will have the outlook appearance.
To:
CC:
BCC:
Email subject title:
Email Body:
"From cell AX to GX" (Give me a empty cell to change the value of "G"; email body should allow me to insert formulae)
Signature:
3) by the click of a macro button, it generates the Outlook emails. Give me an empty cell to determine whether to send out emails automatically or generate but do not send out for my verifications.[/FONT]<img style="box-sizing: border-box; vertical-align: middle; border: 0px; color: rgb(73, 73, 73); font-family: "Gotham SSm", Helvetica, Arial, sans-serif; background-color: rgb(250, 250, 250);">