Marcro to copy sheet out of workbook

[Guest]

Hello,
I am hoping someone can help me with a macro. I need to copy a specific
worksheet (ex 1-15-05) out of a workbook and email it to someone. Any help
will be greatly appreciated.

 

[Guest]

Copying a sheet is easy

sheet1.copy

or

Sheets("Sheet1").copy

In order to e-mail it through code is a little trickier. I am assuming MS
Outlook. You should check out http://www.rondebruin.nl/

HTH

 

[Ron de Bruin]

Hi Mac

See
http://www.rondebruin.nl/sendmail.htm

 

[Ron de Bruin]

Hi Jim

I am assuming MS Outlook.

also Outlook Express and CDO examples for any program (or none)

 

[Guest]

Hi Ron,
I found your webstite. I is wonderful. I installed the program but when I
try to run it. It tries to open pdfword.dot and another screen comes up and
says Microsfot word mail could not be started. I must be doing something
wrong but I'm not sure what. Any help you can give me will be greatly
appreciated. Thank you

 

[Ron de Bruin]

Hi Mac

Check out this first
http://www.rondebruin.nl/mail/problems.htm