Macro to copy paste data as transpose and to send email

[Shiny]

Hi Team

I need to create a macro as follows

My data

Client Versionref Product Emailid
A 1 EL [email protected]
A 10 PL [email protected]
A 18 CL [email protected]
B 8 CCI [email protected]
B 6 EL [email protected]

What I want

The above values needs to be copy pasted in a new workbook as follows
Client EL PL CL
A 1 10 18
Mail Sent Yes Yes YEs ----- This row is standard text for all

the above file should be saved under Temp file by client name and gets emailed to [email protected] through macro

same for client B
Client CCI EL
B 8 6
Mail sent Yes Yes

the above file should be saved under Temp file by client name and gets emailed to [email protected] through macro

Is it possible to do through macro?

Thank you

[marreco]

When you have a time, look ..
http://www.rondebruin.nl/sendmail.htm

Maybe halp you...