E-Mail individual reports?

[Mark121]

Hi all,

Is it possible to email each user in the database their specific report.

I.e i produce a report on a query which brings back everything associated to the User ID. I want to be able automatically email each user there specific report.

Thanks

Mark

 

[Rickster57]

emails

A few years ago I did this where there were over 40 retail stores that received a sales/commission report every two weeks. I would run the report for each store and using the TransferSpreadsheet function I saved the report into a folder for each store. Ex: C:\RetailStore1\TheirReport
C:\RetailStore2\TheirReport

I then put together a module in Microsoft Outlook that fired off and email to each store with their report as an attachment. All that happened in the background and was extremely fast.