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