Hi All,
Hoping that someone can help with VBA code that had served me well in the past but I have been unable to locate again.
In my spreadsheet I need to filter on column containing email address, create a temp workbook containing these rows (can be variable), open email account and send it to the email recipient as per the filter, then keeping looping until the list is exhausted. I would also like to create a subject line and have text in the body of the email.
Has anyone seen any code like this on the forum?
Hoping that someone can help with VBA code that had served me well in the past but I have been unable to locate again.
In my spreadsheet I need to filter on column containing email address, create a temp workbook containing these rows (can be variable), open email account and send it to the email recipient as per the filter, then keeping looping until the list is exhausted. I would also like to create a subject line and have text in the body of the email.
Has anyone seen any code like this on the forum?