Send worksheets in workbook

  • Thread starter Thread starter billy2willy
  • Start date Start date
B

billy2willy

I have different departments (about 18) that I report on, but have them
combined in one workbook. I would like to send them the applicable
worksheet as an attachment and just the worksheet that applies to them.
Is there some way I can load a different email address for each
worksheet, press a button and have them all sent at once, only
containing the applicable information for their department?
 
Hi, Billy. I'm sticking my 2 cents in before you make a mistake. As a VBA
Project Manager, I strongly suggest you create a "management" sheet. In
Column A, put the sheet name, and in Column B, put the email address. Then
have someone code THAT for you. By doing that, even if you create more
worksheets, you can just add them to your "email table" and have it still
work. :) Great Idea, right? Now, if I was only a programmer, I could help
you implement it.
*******************
~Anne Troy

www.OfficeArticles.com


"billy2willy" <[email protected]>
wrote in message
news:[email protected]...
 
Anne Troy said:
Hi, Billy. I'm sticking my 2 cents in before you make a mistake. As a VBA
Project Manager, I strongly suggest you create a "management" sheet. In
Column A, put the sheet name, and in Column B, put the email address. Then
have someone code THAT for you. By doing that, even if you create more
worksheets, you can just add them to your "email table" and have it still
work. :) Great Idea, right? Now, if I was only a programmer, I could help
you implement it.
*******************
~Anne Troy
Click to expand...

As an aside, Lotus allows you to email not only a single sheet from a
workbook, but selected area of a particular sheet! Way to go MS?
 
Sorry, Gordon. Good luck finding someone who could send all 18 using some
code in Lotus. Those coders are much fewer, far between, and more expensive!
*******************
~Anne Troy

www.OfficeArticles.com
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Collate Worksheets into single workbook 3
Sending sheets in workbook 4
Consolidate data from multiple worksheets into one 2
Trace links between worksheets within one workbook 4
Consolidate workbook template 1
Apply different color themes to worksheets withing a workbook 2
save each sheet of a workbook as its own workbook 3
consolidate workbooks to worksheets in one workbook? 1

Back
Top