I am using excel 2016. Would like to send an auto email to multiple staff. Would like to attach one or more selected rows of specific data from my worksheet. Not sue if VBA is the direction I need to go using a Command Button or use macro coding where I can select the individual row(s) of data to attach to the email. I am not proficient with VBA or writing and understanding macro processes. Can the auto email be a formatted email I created in Outlook? I have attached a Test workbook. The columns in purple is the data range I want to attach to the auto email. There could be as many as 6 rows selected to attach to the auto email.
Solved by T. Y. in 14 mins