e-Invoices on sharepont from Access

[Niebotel]

For a harbour I created a application in Access with the table on a sharepoint.
Until now the 150 invoices for the members are sent twice a year by tradional paper post.
Now we want to auomate the process bij placing de invoices on the shatepont.
I'm looking to a rather simple way to distribute them bij email or (preferrable) show the invoice on the sharepoint. In that case the user should only see its onw invoice. Can you give me some hints how this can be solved?
One one hand storing the reports directly from access and making them available only for the user for which the invoice is ment.

 

[ehaze]

Can customers view your SharePoint site?

In what format are you wanting to deliver the invoices?
PDF, Word, ....

http://www.sharepointed.com/

 

[Niebotel]

Yes my customers (members) cab view the sharepoint site. They all have an individual account

Probably the best way is in pdf.

 

[ehaze]

Create the invoices using Access.
Have Access output the invoices to a SharePoint library.

Create a workflow in the SharePoint library that emails the customers.

This is a greate FREE set of tools that add more function to your workflows:

http://ilovesharepoint.codeplex.com/

Using the added functions, you can set unique permissions on each item in the SharePoint library.

http://www.sharepointed.com/