From one worksheet create multiple worksheets?

[Gary J. Dikkema]

I located the macros that allow the creation of multiple sheets within the
same workbook.

I'm also looking for the ability to email tables and or reports from within
an Access database.

Anyone?

TIA.

 

[Joseph Meehan]

I located the macros that allow the creation of multiple sheets within
the same workbook.

I'm also looking for the ability to email tables and or reports from
within an Access database.

Anyone?

TIA.

Sorry. This is a newsgroup dedicated to questions about Access, the
database program in Office Professional. It appears your question may not
be related to these subjects. The Microsoft help system is not all that
clear and may have misdirected you here.

It is best to ask your questions in a newsgroup dedicated to the
subject of your question. You should find people better able to address
your problem there.
http://tc2.atspace.com/0013-HowToSearch.htm#FindNewsgroup may help.


Note: It is always best to indicate the name and version of any
program(s) you may be using when asking a question and also indicate the
operating system (like Windows XP or 98) when you ask a question.

 

[Guest]

In Access use the sendobject function. YOu can find help files that tells
you how to set it up.

 

[Gary J. Dikkema]

Sorry. I asked for TWO MS products.

OK, lets stick to MS Access.

 

[Guest]

See my previous post

 

[Gary J. Dikkema]

Had a look at that...

I probably want something more fully featured. If I don't have to re-invent
the wheel that works for me.

 

[Joseph Meehan]

Sorry. I asked for TWO MS products.

OK, lets stick to MS Access.

Sorry, I missed the second paragraph. This is the place.

Sorry I don't have any specific answers for you. That is something I
have never had to address.

 

[Douglas J. Steele]

See whether the Access EMail FAQ that Tony Toews has at
http://www.granite.ab.ca/access/email.htm helps.

 

[Gary J. Dikkema]

Saw the EmailSenate and EmailSenate2k there...

Only problem there is it seems to create multiple pages of the same
report... and not even all of the information based on my standalone testing
this morning with both of those. Otherwise I think it might just fit the
bill.

Does it not work in Access 2003?

 

[Guest]

The 2k2 should work with2k3 as they are essentially the same.

 

[Gary J. Dikkema]

Agreed!

When I run the macro it creates page 1 and page 2 html report files that get
attached to the email. BUT, each report file actually is ALMOST the complete
file.

Emailing works well it's just the content seems NOT to be complete IMO.

It would be easy to integrate into my application. BUT... I haven't figured
out WHY there are two pages for the report that are both the same. Err,
almost the same, I added three or four lines to the table that the report
prints but not everything gets listed. Strange!