hi, i am seeking help on how to automate below process and write a vba.
Case: i have an excel file whereby column K = date, column E, G = email address that i am going to send an email to. header is in row 2.
usually, i will filter to column K the month that i am working on, send an email to each customer base on the respective Column E, G cell for the email address.
in the email subject, will indicate "reminder - [customer]" -> customer will be the value found in column A
Email content:
line 1: hi,
line 2: this is line 2.
line 3: copy the table over with header row 2 and its respective row (without column I and J)
example: if i filter to Mar 2020, i will need to send 3 emails out.
the 1st email will be sent to E3, G3, subject: reminder - A3
hi, this is line 2, copy the table from range A2:L2 and A3:L3(without column I and J)
2nd email will look like this.
send to E6, G6, subject: reminder: A6
hi, this is line 2, copy the table from range A2:L2 and A6:L6 (without column I and J)
thanks in advance.
Case: i have an excel file whereby column K = date, column E, G = email address that i am going to send an email to. header is in row 2.
usually, i will filter to column K the month that i am working on, send an email to each customer base on the respective Column E, G cell for the email address.
in the email subject, will indicate "reminder - [customer]" -> customer will be the value found in column A
Email content:
line 1: hi,
line 2: this is line 2.
line 3: copy the table over with header row 2 and its respective row (without column I and J)
example: if i filter to Mar 2020, i will need to send 3 emails out.
the 1st email will be sent to E3, G3, subject: reminder - A3
hi, this is line 2, copy the table from range A2:L2 and A3:L3(without column I and J)
2nd email will look like this.
send to E6, G6, subject: reminder: A6
hi, this is line 2, copy the table from range A2:L2 and A6:L6 (without column I and J)
thanks in advance.
