create new mailmessages depending for each customer

[Gribbs]

Hi Everyone!

please see attached file first.

Now, If you use the macro named "x" it will produce information to sheet3.
the information is grouped by customer. I want each customer to have their information/stats sent to their mailadress(es) found in the Mailinfo-sheet.
With other words. I need help with creating vba code that open up new mailmessages for each customer that exists on sheet3 and add that customers stats from sheet 3 in the body of the mailmessage.

I have made an example of how I want a new mailmessage to look like on sheet4.

So far, I have created two modules (I found the code with google). But what they do is to open up new messages for each customer in the mailinfo list. Instead, I want it to open up new mailmessages for each customers on sheet3.

So, could anyone of you help me to create the VBA code to make this happen?

Thanks in advance!

//Gribbs

[Gribbs]

Noone who can help me ? ^^

[jaslake]

Hi Gribbs

Please see attached. Note that I've added a dynamic Named Range to Sheet Mailinfo called "Name". Also note that I've modified your "x" macro and that I've modified the "RangetoHTML" code.

Let me know of issues.

[Gribbs]

Thank you ALOT Jaslake!

that was amazingly well done!

//Gribbs

[jaslake]

Hi Gribbs

You're welcome...glad I could help.