Macros and Email

[Tomcat57]

I am looking to write a macro that takes worksheets from a workbook
protect them, save them to idividual workbooks and then email eac
individual workbooks to nn addresses. All of this off of minimum ke
strokes.

The macro to protect, copy, and resave worksheets as a new workbook i
fine, but I am struggling to email the individual worksheets off of th
same macro function. Any ideas would be welcomed.

With grateful thanks

T

 

[GS]

Tomcat57 explained on 7/3/2012 :

I am looking to write a macro that takes worksheets from a workbook,
protect them, save them to idividual workbooks and then email each
individual workbooks to nn addresses. All of this off of minimum key
strokes.

The macro to protect, copy, and resave worksheets as a new workbook is
fine, but I am struggling to email the individual worksheets off of the
same macro function. Any ideas would be welcomed.

With grateful thanks

TC

You'll find very helpful examples listed here...

http://www.rondebruin.nl/tips.htm

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion