Splitting data on one sheet to multiple sheets and mailing as attachment.

[Viking]

Hi.. I have been a fan of this site. I am stuck with a problem.

I have a sheet of data where in Column "C" there are multiple customers. I need to send out email to each customer with their relevant data as an attached excel sheet.

Since the number of rows of data is large (and varies for each customer) , I would like to have a vba code that splits data into multiple sheets and attach them to outlook as email attachments.

The email ids (multiple) for each customers is available on another sheet as master table.

Can you please help.

 

[Luke M]

Breaking that down into 2 problems. First, the splitting the data. I'd suggest checking the articles here for code examples:
http://www.rondebruin.nl/win/section3.htm

For the mailing, see this section:
http://www.rondebruin.nl/win/section1.htm