E mailing a report

[EmmaJane]

This is probably something very simple but I have searched help and this forum and cannot not find a solution, well at least not one that I can understand !

I have been asked to produce a report in access which I have done no problem but this needs to be e mailed on a regular basis, keeping it’s current format and layout, however it cannot be done via snapshot as it’s going to a local authority and they cannot read it and cannot download the viewer. They have requested it be in either excel or word. I have tried but cannot get it to appear as it does in my access report.

Any help or suggests that anyone can offer would be great, bearing in mind that I am not that great with access so it needs to be fairly simple !!.

Regards

 

[Hayley Baxter]

Hi Emma

You may want to have a look at this thread. There is a link in this thread where you can download an example of taking your access report accross to word keeping the same format as it appears in access.

http://www.access-programmers.co.uk/forums/showthread.php?threadid=55312

Hope this is helpful
Hay

 

[EmmaJane]

Cheers Hayley,

Just having a look now will let you know how I get on

 

[EmmaJane]

Hayley,

Tried that downlaod but could not get it working ! Is there anything else you could suggest.

Thanks

 

[Hayley Baxter]

What problems are you having with the download?

Another option would be to save the report as a PDF file. There is a good link here

Let me know how you get on with that.

Good Luck
Hay