Microsoft Access 2003, Emailing Reports?

Tican · 3 Jun 2008 at 14:41

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

Kaed · 3 Jun 2008 at 15:32

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?

Tican · 3 Jun 2008 at 17:25

I don't have the ability to install things at work

Office Links, will have to look at that one

RockLobster · 4 Jun 2008 at 20:04

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