http://www.gssitaly.com/filtre_and_send.zip

My problem:

Step by step.

TIPE OF FILTRE
Example for your experiment is SO.FARMA.MORRA S.P.A.

Filtre from column C.
Send only the filtered sheet for this INTESTAZIONE.
The db of email is in the sheet E_MAIL.

Add the summ of record in D1 of the sheet filtered

TIPE OF EMAIL
Example for experiment is SO.FARMA.MORRA S.P.A.
subject of email:
INSOLUTI & SO.FARMA.MORRA S.P.A. & string in RANGE A & string in RANGE B & string in RANGE I & date sended sheet

Final result of subject:
INSOLUTI SO.FARMA.MORRA S.P.A. 235 04500 40260 25/07/2004

NAME OF SHEET
Final result Name of sheet sended same option of the subject:
INSOLUTI SO.FARMA.MORRA S.P.A. 235 04500 40260 25/07/2004

Before the send email make a copy in C:\INSOLUTI_SENDED\... put here the file sended

Note: the joint string from column A and column B and column I is the index

Nothing INTESTAZIONE are equal from this joint

Note1: the strucure of the file to send is the same from the master shet IMPGATI

hope i am clear....