Can you email a report? 2

[rayna]

I have written several reports that print on 11x17 paper. Unfortunately, we only have one 11x17 printer on which to print it, and it is not networked. So I need to know, if I run a report, can the results be e-mailed to the one person who is hooked up to the 11x17 printer so he can print it? I am thinking "no"....but I am just checking....

Thanks,
Rayna

 

[jebry]

Hi Rayna!

Check out SendObjects in Access help. It may do what you want.

hth
Jeff Bridgham
bridgham@purdue.edu

 

[genomon]

If you just want the printed report, without the ability to open it in Access, get Adobe Acrobat Writer (not the free reader) and save as a .pdf file to attach to the e-mail. Use "Distiller" as the printer when you click on File | Print.

 

[rayna]

Thanks, Jeff - that worked perfectly!!

Genomon, thanks for that suggestion, but guaranteed my boss will not invest in anymore software

Rayna

 

[DomP]

Rayna,

I may be missing something but can't you print/save it as an .rtf file. That's how we send reports all the time.

Dom

 

[rayna]

Dom,

Well, I just opened a report in Access, and there's no option to save it as .rtf. Just "save as..." and the alternative to save it within the database or in a different one, or save as HTML.

How do you go about that?

Rayna

 

[DomP]

Sorry, should have been clearer. Run The report first, then the tool bar should give you an option to save as a Word file (which is .rtf). The other option is to click on file and export the results to a .rtf. file.

Dom

 

[rayna]

Sorry, Dom - I see now what you mean.

In fact, I already tried that but it takes out all my headings and the lines that seperate the fields and all that sort of thing....prints data only, as far as I can see. Unless, of course, I am missing something. Am I? ;-)

Rayna

 

[DomP]

Are you actually looking at the .rtf file or the report via the Access screen. There is an option under file/page setup in Access that prints data only and that is what you get in Access but once it goes to the .rtf file the headings appear that's why I ask.

Dom

 

[rayna]

Dom -

Thanks for the suggestion, but nope - my "Print Data Only" is unchecked. And when I open the .rtf file with Word, it still gives me data only.

Weird, eh? Does the size of the report have anything to do with it? One of my smaller reports does what you say it should.... opens in .rtf perfectly. Any suggestions as to why?

Rayna

 

[DomP]

Rayna,

At the moment no. We use it for reports ranging from a couple of pages to 150 pages without any ill effects. A little puzzled at the moment. Based on your question about the size of the report how about only printing a portion of the report and see if that has an effect?

Dom

 

[rayna]

Dom -

Nope....nada.....

I don't understand either, but I guess it does not really matter. Would it matter that the headings are all things I added....unbound labels and the like, that are not "connected" to the data? Or should it all just print as is, end of story?

Rayna

 

[DomP]

Rayna,

Not sure but it must have something to do with how the headers were created. I would delete and recreate the header and see if that fixes the problem.

Dom

 

[rayna]

You know what, Dom? It's just not *that* important X-)

But I do appreciate all the help you have given me.

Thanks, Rayna Man plans. God laughs.

 

[mustangirl]

Try saving it as a snapshot instead of an rtf.

Shawndra Jones

 

[RegionsRob]

Yes, save the report as a Snapshot. This preserves the same formatting that you see on the screen. For some reason, JET and RTF use different algorithms to determine print formatting, so RTF will rarely be identical to the on-screen version.

Use docmd.OutputTo... In Access97, I have to use "Snapshot Format" for the outputformat argument. (Hopefully 2000 has incorporated a constant for this.) See article Q175274 in the MS Knowledge Base for more info and the link to download this FREE reader.

There are 2 big advantages to using Snap instead of Acrobat. (1) Snap is FREE, (2)Snap is not grainy and bitmapped like .pdf docs.