create files from a spreadsheet
 

Each month I need to create a separate excel file for each customer with an
accounting of errors

I have a template with 6 fields that need I enter data into. I then save
the file and e-mail it to the customer for corrections.

I have another speadsheet that contains the data for each of the 6 fields
that I am entering.

Can anyone explain how to automate this process?

create files from a spreadsheet
 

Hi PetNetwork

Why not create 6 sheets(for every customer ) and link(formula) to the information in the other workbook
You can use a macro like this then to mail if you also enter the mail address in each sheet
http://www.rondebruin.nl/mail/folder1/mail5.htm

--
Regards Ron De Bruin
http://www.rondebruin.nl



"PetNetwork" wrote in message ...
Each month I need to create a separate excel file for each customer with an
accounting of errors

I have a template with 6 fields that need I enter data into. I then save
the file and e-mail it to the customer for corrections.

I have another speadsheet that contains the data for each of the 6 fields
that I am entering.

Can anyone explain how to automate this process?