Macro to send Email to Unique Recipients

Hi guys,

I managed to build a macro to send out emails using the following guide - http://spreadsheetpage.com/index.php...ail_from_excel

However I've received feedback that the same recipient would like to receive 1 email for the data that belongs to him. This differs from the current emails, where 1 line in excel generates 1 email.

Is there anyway to combine the data for the emails, based on the email address, before sending it out?

Thanks and apologies in advance if this has been addressed before, I've tried looking in the past threads already.

Please Login or Register  to view this content.

Maybe this link will provide hep

Hi, thanks for the link, I'll have a look at it later.

But does anyone know if it's possible to add some lines into the macro? Because I'm already using my own version to send 50 emails a day so I would like to minimize the changes if possible.

Thanks.

Any gurus out there with any suggestions?

any experts out there with suggestions?