Hi guys, im trying to generate multiple e-mails from a sheet with a check for duplicates.
Example:
Column A contains data "[DATA1]", Column B contains data "[DATA2]", Column C "[DATA3]" contains data , all data is to be included in the body of the message.
Column D contains an e-mail address "[EMAIL]", Column E contains a name "[NAME]".
There are multiple rows of data & corresponding e-mail addresses & names.
What I would like is a macro that would check for duplicates in Column D and if found combine the data in each row to a string that would then go into the e-mail body.
I've attached an example. The final e-mail would like something like this (example e-mail is to an customer who has multiple rows in the sheet - these could be ordered randomly in the sheet):
To: [EMAIL]
Cc: (a value stored as string - this value is static)
Hi [NAME],
The current status of your orders is:
[DATA1a] is currently [DATA2a] and it would be ready on [DATA3a] (<- data from a row in the worksheet)
[DATA1b] is currently [DATA2b] and it would be ready on [DATA3b] (<- more data row from another row in worksheet)
If you have any questions please don't hesitate to contact me.
Regards,
Me
If anyone knows what the best way of doing this would be I would really appreciate your input.
Bookmarks