Help Programming Email Via Excel Spreadsheet

Hi all,

I am trying to create a macro from a sheet formatted in the following way: (the sheet is a list of products we do not have in stock)

Please Login or Register  to view this content.

What I want to happen when I run the macro is an email is created/sent for each UNIQUE email address with a list of the parts that we have been unable to deliver to them.

So for the example above, the email would read:

Please Login or Register  to view this content.

I have played around with the following, but am struggling with a way to tell excel to compile all shorts with the same email...

Please Login or Register  to view this content.

Any help with this would be appreciated.

And also what code would include the default signature from my outlook?

Thanks in advance

Hi,

Thanks for the reply. I'm not sure the above would address my problem?

To clarify, the spreadsheet would be 50 lines+, so to use the filter function would take too much time really.

I'm really looking for one Macro that would do all emails if possible?

Originally Posted by bakerman2

Or use Dictionary to create unique list and email.

Please Login or Register  to view this content.

I'm just playing with this one now.....

Hi,

No, I can't get that to work for me. My list may have 30 different emails on, with many of them repeated. I need the macro to create one mail per unique email address, but include the details from all rows associated with that email address...

I apologise for my lack of coding knowledge....

Hi Bakerman,

The Macro runs, but no emails are generated?

Am I doing something wrong here (been a loong day!)

Sorry, to correct myself there...

It's almost there. Just 2 small points.

1. The macro creates the mails, but how do I get them to send rather than just create them.
2. How would I go about adding my default signature to the emails?

Many thanks for your patience!! It really is appreciated!