Linking Database to invoice/email template

[Guest]

I have designed my database and on inputting a new supplier I would like
Access to generate an invoice in excel and an email in outlook express, is
this at all possible as can't seem to find anything like this in my step by
step book.

 

[Guest]

It can be done using VBA. You'll have to tackle it in 2 parts:

1. Export to Excel
2. E-mail

Both of these have been answered numerous times. Thus your best bet is to
search this forum, or google groups. You will find the info you seek.
Otherwise, you would need to provide more info about your export needs for
someone to be able to guide you best.

Is it a bulk dump or a cell by cell job? What about saving the generate
excel file. Overwrite existing or give new name (based on what)?

 

[Tony Toews [MVP]]

I have designed my database and on inputting a new supplier I would like
Access to generate an invoice in excel and an email in outlook express, is
this at all possible as can't seem to find anything like this in my step by
step book.

Actually I'd create the invoice in a PDF format. Making sure you
retain a copy of course. That way it's more difficult for the folks
at the other end to muck with it.

A2000ReportToPDF is an Access 2000 database containing a function to
convert Reports and Snapshot files to PDF documents. No PDF Printer
driver is required.
http://www.lebans.com/reporttopdf.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/