Code to send report by email or fax

[lakb]

Hi

I have some 100,000 data lines that need to be sent to approx 180 branches around Australia on a weekly basis. I have developed the queries and created a suitable report. However, I was wondering how I might develop coding that could run this report 180 times and for each time email the report to the appropriate branch. I have a table of branches with email, phone, fax details etc.
Would it be easier to have the coding fax the reports?.
Last question (I am pushing my luck) could this then be scheduled to run over night

Any assistance appreciated.

 

[hillsy]

Hmmmm, can you create an email group and just attach the report.

 

[KenReay]

Hi

You can do what you are trying to do, but you perhaps need to experiment to achieve optimum result.

To schedule the run either use the windows scheduler, or the timer in Access

To send your report see DoCmd.OuputTO and DoCmd.SendObject in help

Do you have to send the same report to all 180 branches?

If yes, then hillsy idead of having an EMail group is sound, since you would then just have to run the report once, but if each branch gets a customised version of the report, you have no option but to do 180 runs as far as I can see Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[lakb]

HI

I have to run the report 180 times with each branch getting only their required information.

I will test the docmd lines.

Thanks for the advice.

Bernard

 

[PWise]

see my answer in

thread181-449500