It's obvious that I am not explaining myself too well much as you have tried
to help me Ron. <VBG

So let me start over.

I have an Access database and I have to be able to or I'd like to be able to
email reports to 57 people in different parts of Manitoba Canada.

I have tables that if they were sorted on City you might say each table
would be like looking at 57 tables combined into one table.

So I found - on the web - ExtractReps which takes one of my exported to
Excel tables and from Sheet1 creates those 57 Sheets, each identified with
by the city names rather than Sheet2 to Sheet57.

So... I figured I'm almost there, all I really need is a simple macro that
will create 57 emails, each with their own attachment.

From the links that you have sent me I don't see that. I hope I didn't
overlook anything Ron, I like the TestFile macro, except it doesn't handle
my sheet names... or for that matter any sheets. Otherwise than that it
could be set up once and all I'd have to do is add in the different XL
worksheets or for that matter any file.

I don't know if this helps you see what I'm struggling with or not.

Here's hoping that you can help me.

Regards,

Gary Dikkema



"Ron de Bruin" wrote in message
...
Hi Gary

You can enter the file name in the template

Why not use this to send each sheet to the person you want
http://www.rondebruin.nl/mail/folder2/mail5.htm

Or
http://www.rondebruin.nl/mail/folder3/mail5.htm


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


"Gary J. Dikkema" wrote in message
...
Ron,

For me the templates would be the best.

I will be creating XL files for 57 people, each in their own sheet using
a macro I located on the web, but... I would prefer to use the name of
the Sheet rather than sheet2 or sheet10 or sheet56.

In my case this will be city names and is easier to track.

I could then set up one standard worksheet with this all encoded and then
just run it.

Could your template be changed to do this?

Many thanks!

Gary D



"Ron de Bruin" wrote in message
...
Hi Gary

Install my Add-in
http://www.rondebruin.nl/mail/add-in.htm
You can select the sheets you want then

Or use a template
http://www.rondebruin.nl/mail/templates.htm


Or use code
http://www.rondebruin.nl/mail/folder1/mail3.htm

Or
http://www.rondebruin.nl/mail/folder2/mail3.htm


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


"Gary J. Dikkema" wrote in message
...
http://www.rondebruin.nl/mail/folder2/files.htm

I like the Mail a different file or many files...

I tried to use this to selectively send sheets within a workbook.

No luck!

What would need to be changed?

TIA.

As a background I have a spreadsheet with 57 sheets with names of town
and I'd like to be able to select using this.

Nothing like asking for the moon eh! <VBG