PC Review


Reply
Thread Tools Rate Thread

Copying worksheets into separate workbook and emailing separately.

 
 
mistlecane
Guest
Posts: n/a
 
      9th Jul 2008
I have a company that wants me to mail 18 different worksheets into 18
different emails, with different subject lines. Any ideas?
 
Reply With Quote
 
 
 
 
mistlecane
Guest
Posts: n/a
 
      9th Jul 2008
FYI , EXCEL 2002, OUTLOOK 2002. Thanks

"mistlecane" wrote:

> I have a company that wants me to mail 18 different worksheets into 18
> different emails, with different subject lines. Any ideas?

 
Reply With Quote
 
Ron de Bruin
Guest
Posts: n/a
 
      9th Jul 2008
See
http://www.rondebruin.nl/mail/templates.htm

Or only code
http://www.rondebruin.nl/mail/folder2/mail5.htm



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"mistlecane" <(E-Mail Removed)> wrote in message news:4A37C042-BCF2-4798-9E87-(E-Mail Removed)...
> FYI , EXCEL 2002, OUTLOOK 2002. Thanks
>
> "mistlecane" wrote:
>
>> I have a company that wants me to mail 18 different worksheets into 18
>> different emails, with different subject lines. Any ideas?

 
Reply With Quote
 
mistlecane
Guest
Posts: n/a
 
      10th Jul 2008
Ron,
I implemented your code and it works beautifully!! Thanks

"Ron de Bruin" wrote:

> See
> http://www.rondebruin.nl/mail/templates.htm
>
> Or only code
> http://www.rondebruin.nl/mail/folder2/mail5.htm
>
>
>
> --
>
> Regards Ron de Bruin
> http://www.rondebruin.nl/tips.htm
>
>
> "mistlecane" <(E-Mail Removed)> wrote in message news:4A37C042-BCF2-4798-9E87-(E-Mail Removed)...
> > FYI , EXCEL 2002, OUTLOOK 2002. Thanks
> >
> > "mistlecane" wrote:
> >
> >> I have a company that wants me to mail 18 different worksheets into 18
> >> different emails, with different subject lines. Any ideas?

>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Merging Separate Worksheets into one Workbook =?Utf-8?B?SmltIEpvaG5zb24=?= Microsoft Excel Misc 1 3rd Nov 2006 01:35 PM
copying worksheets to a new workbook without formulae referencing original workbook pjdeeb@gmail.com Microsoft Excel Programming 2 16th Oct 2006 07:31 PM
How do I separate worksheets in a workbook into individual files? =?Utf-8?B?am1k?= Microsoft Excel Worksheet Functions 3 13th Dec 2005 09:18 PM
Linking/connecting nine separate worksheets of a workbook =?Utf-8?B?QWFtaXI=?= Microsoft Excel Discussion 3 8th May 2005 09:05 PM
Emailing worksheets within a workbook as ATTACHMENTS =?Utf-8?B?Q2F0Y2ggMjI=?= Microsoft Excel Misc 3 18th Mar 2005 08:45 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:33 AM.