Re: Emailing selective sheets within a workbook.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi Gary

You can enter the file name in the template

Why not use this to send each *** 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" <gary_d-no-spam-@xxxxxxx> wrote in message news:OO0KwXlYGHA.2208@xxxxxxxxxxxxxxxxxxxxxxx
Ron,

For me the templates would be the best.

I will be creating XL files for 57 people, each in their own *** 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 work*** with this all encoded and then just run it.

Could your template be changed to do this?

Many thanks!

Gary D



"Ron de Bruin" <rondebruin@xxxxxxxxxxxx> wrote in message news:OEg3TElYGHA.1016@xxxxxxxxxxxxxxxxxxxxxxx
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" <gary_d-no-spam-@xxxxxxx> wrote in message news:eHZP49kYGHA.4796@xxxxxxxxxxxxxxxxxxxxxxx
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>









.

Quantcast