I have an excel file with data as shown. I want to email details pertaining to customer from Excel. There could be more than one invoice details for a customer. The code has to email details pertaining to one customer and loop through untill it finds another customer. Pls advise and help.Book2.xlsABCDE1CustomerInvoiceDateAmountEmail2Rose10105-Nov100rose@yahoo.com320506-Nov200420804-Apr451520905-Jul4786Lotus20210-Oct124lotus@yahoo.com721012-Dec4148Corsa30301-Jan910corsa@yahoo.com930405-Mar7401030505-Apr14011Nima40409-Aug157nima@yahoo.comSheet1 Thanks, Rakesh

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Excel to Email

Thread starter Rakesh_Parekh
Start date Nov 9, 2005

Rakesh_Parekh

New Member

Nov 9, 2005

I have an excel file with data as shown. I want to email details pertaining to customer from Excel. There could be more than one invoice details for a customer. The code has to email details pertaining to one customer and loop through untill it finds another customer. Pls advise and help.

Book2.xls