Emailing Reports

[Guest]

Hi,
I have a table of data that is updated each day. During the month I want to
send a copy of this data to each shop. I want each shop to only receive data
relating to them.
I was thinking of making queries/reports for each shop, then putting them
into one Macro using SendObject. And then just running that macro when I
need this done.
I am told this is a very long way of doing it...Does anyone have a better way?

 

[Guest]

Hi Spin,

You only need to make a single report that has a query that either prompts
you for the ID of the shop you want to send it to, or picks the value up off
a form.

The query would be something like "select * from ShopData where ShopID =
[Enter Shop ID]"

If this query was run, a box would pop up asking you for the Shop ID.

Of course, if you have 100 shops then you might want to automate this using
code.

Hope this helps.

Damian.