Microsoft Access 2003, Emailing Reports?

Soldato
Joined
14 Apr 2003
Posts
5,716
Location
Leicester
Hi all,

Unsure if this is the correct section?

I am needing to create a report, and once ran it can email it (or even add it as an attachment in Outlook then all I would need to do was input the email addresses), using Outlook,

Is this possible?

I have seen a few hints at PDF documents, but would need to do Excel ideally!


Thanks in advance,

Ian
 
If memory serves correctly, isn't there a 'Office Links' toolbar button ?

Or am I thinking of something else?

Allows you to export your data to other office applications (Excel for example)

Alternatively, you could install something like PDFCreator (free PDF creating tool) and just 'print' your report to that?
 
I don't have the ability to install things at work :(

Office Links, will have to look at that one :)
 
Hi

There's two ways, writing a bit of code or use a macro. Ok using the macro method. Click on new macro, action must be SendObject, object type is report, object name is the name of your report, you should know the rest.

You can either run the macro from code or just create another macro to run your report first then run the above macro.

Here is the code solution if you wish to use that http://www.utteraccess.com/forums/showflat.php?Cat=&Number=682597&Main=679680
 
Back
Top Bottom