By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,067 Members | 1,227 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,067 IT Pros & Developers. It's quick & easy.

send current report as attachment

P: 59
I made a report who has many pages.
Now,I would like send current page in a report (like attachment) to Microsoft office outlook, but i do'nt know.
I tried , but always send all pages from a report.
thanks for you answer!
Feb 4 '08 #1
Share this Question
Share on Google+
3 Replies


Expert 100+
P: 446
Hi

What version of Access are you using?? I hear in 2007 you can have 'clickable' controls so that might help.

How are you outputing your current report to Outlook? As a Snapshot ?

A 'low tech' solution would be to use Ctrl+P to open the print dialogue select you page/pages then output to PDF 'printer' but then you may have to manually attach these to an email.

VisageSoft eXPert PDF software (free download) allows you to append directly to email instead of saving to disc so this might help.

S7
Feb 5 '08 #2

P: 59
Hi

What version of Access are you using?? I hear in 2007 you can have 'clickable' controls so that might help.

How are you outputing your current report to Outlook? As a Snapshot ?

A 'low tech' solution would be to use Ctrl+P to open the print dialogue select you page/pages then output to PDF 'printer' but then you may have to manually attach these to an email.

VisageSoft eXPert PDF software (free download) allows you to append directly to email instead of saving to disc so this might help.

S7
When I go to File and select Send to I open Send windows where I must select format.
I choose snapshots format and press OK then All page from report sent to Outlook.
I would like send only current page.
I see too on right corner in Send windows Output (All or Selection) option but I have not access.
My version is Access 2003.
Feb 6 '08 #3

Expert 100+
P: 446
The option to send Selection or All is activated when you are able to select a part of your document. For instance if you open a Table you can select the first 100 rows and send as a Snapshot document as a 'selection' or the whole table.

It's not much use in a report though as you can't select pages. Even if you save the SNP file, either by the Export option or programmatically with DoCmd.OutPutTo, you still cannot divide up the report into pages other than using the Printer software. A challenge for sombody perhaps??

I've searched for the Object Model of a Snapshot document but have drawn a blank so far.

I'm out of ideas now other than using the PDF route.

Sorry

S7
Feb 6 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.