Hi,

This is what I need to do:

I have a file with about 40 Worksheets containing customer statements,
every month I have to send them each seperate statement through email.
The orignal file is setup such that 1 main worksheet recieves data from
external source and populates statements in all the other worksheets.

Every month I move each worksheet to a new file and convert formulae to
values and send it to the customer. That 40 worksheets and hell a lot
of time.

Is there an easier way of moving worksheets then doing it one by one?

Cheers...
-Azm

It is quite a simple task to do that process.

You need to have the email addresses in the worksheet.

You then do a loop going through the entire workbook except for the first
sheet and save a copy and then email that sheet.
You should create a log file to record the actions so you have a record too.

--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Azm" wrote:

Hi,

This is what I need to do:

I have a file with about 40 Worksheets containing customer statements,
every month I have to send them each seperate statement through email.
The orignal file is setup such that 1 main worksheet recieves data from
external source and populates statements in all the other worksheets.

Every month I move each worksheet to a new file and convert formulae to
values and send it to the customer. That 40 worksheets and hell a lot
of time.

Is there an easier way of moving worksheets then doing it one by one?

Cheers...
-Azm

See example on this page
http://www.rondebruin.nl/sendmail.htm

See also the templates


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Azm" wrote in message oups.com...
Hi,

This is what I need to do:

I have a file with about 40 Worksheets containing customer statements,
every month I have to send them each seperate statement through email.
The orignal file is setup such that 1 main worksheet recieves data from
external source and populates statements in all the other worksheets.

Every month I move each worksheet to a new file and convert formulae to
values and send it to the customer. That 40 worksheets and hell a lot
of time.

Is there an easier way of moving worksheets then doing it one by one?

Cheers...
-Azm