Exporting Reports

[SASHA_D]

Hi Everyone,

I've been searching the forums but can't find exactly what I'm looking for.....

Basically I have a report, based on a query, formatted with a page for each area manager. There are now 45-50 area managers and it's becoming a hassle for them to search through the report and just pick out their own page.
I'd like to press a button where it runs the report and exports it to word, but instead of just one report it exports each page as a seperate file, saved with the area managers name in the same file directory. (Or have each one e-mailed to the appropriate manager).
I'm sure it most be possible through a little bit of code or something, but I'm not sure how to get started.
I assume I'd have to use the record source to reference the area manager field??-not sure how to put them in seperate files and/or e-mail them??

Thanks in advance,

Mr D

 

[Hayley Baxter]

Would you prefer to email all of the Area Managers yourself ie send an email to all by click of a button once you have filtered the records so that the correct page goes to each person

OR

Do you want to allow them a combo selection where they can find their name in the list and it will then export this page to word for them?

Let me know

Hay

 

[Hayley Baxter]

Here a little sample in A200 for option2 above

My table is named company but just take that as The Area Manager.

If you want a sample of Option1 just let me know.

HTH
Hay

 

[SASHA_D]

Hi Hayley,

Thanks for the reply!......
It would probabaly be the first option-the area managers won't be accessing the database (most don't have Access installed)
Although, I'd probably not want to send an e-mail while I'm thinking about it-I only have their intials stored in the database and I presume I'd have to go through the corporate address list and enter all the names exactly as they appear there.
My ideal soloution would be to have a button that when pressed would run the report lots of times filtering for each area manager-exporting them as a word (or RTF) file with the intials of the area manager in the filename and saving them all to the same file directory-the area managers or other staff on their behalf could then pick-up the relevant report.
I understand I would need some kind of looping code that would reference the area manager field???
(I'm pretty new to all this VBA stuff!)

Thanks Again!!,

Mr D

 

[Hayley Baxter]

Have you seen my long winded email thread by any chance?? This will give you you're looping code and the sample above I posted is filtering the records. I'll see if I can find that post for you to have a read through.

Here's the post:

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=32416&highlight=email

By the way which version of access are you using?

Hay

 

[SASHA_D]

Hayley-Thanks so much!,

No I havn't seen the long-winded e-mail thread-that would be useful.
I'm using Access 2000.

Thanks again-I'm now getting hopeful of meeting my deadline for this!

Mr D

 

[Hayley Baxter]

No problem, hope the sample above helped. Have a read through my post above and if you're not sure of anything just give me a shout.

Best of luck
Hayley