EmailSenate and EmailSenate2k

G

Gary J. Dikkema

Is there a way to send selected sheets from a workbook?

These routines work great EXCEPT I have many sheets inside a workbook and
have to route the sheets selectively.

FWIW, I have 57 sheets inside workbooks.

Justas a FYI, I am asking for this advice as well as the ability to create
unique workbooks as opposed to many sheets within a workbook...
 
J

John Vinson

Is there a way to send selected sheets from a workbook?

These routines work great EXCEPT I have many sheets inside a workbook and
have to route the sheets selectively.

FWIW, I have 57 sheets inside workbooks.

Justas a FYI, I am asking for this advice as well as the ability to create
unique workbooks as opposed to many sheets within a workbook...

You may want to ask this question in an Excel newsgroup. Access (the
subject of this newsgroup) doesn't use worksheets.

John W. Vinson[MVP]
 
G

Gary J. Dikkema

I've been working too hard.... and not getting the solution I want.

Of course Access doesn't have sheets. Silly me! <VBG>

However, these two program are Access programs and there seems to be an
issue such as why are two reports produced? And why is data I added not
printed.

Otherwise it routes data to email just fine.

And the bit about the sheets is that I could modify one of these programs by
adding in a control table and use that to create those 57 speudo sheets that
I do now in Excel...

I know, I am all over the map with this... don't mean to be! <VBG>

Thanks for the heads up.

Gary D
 

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

Top