 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / September 2007Linking Database to invoice/email template
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. 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)?  SignatureHope this helps, Daniel P > 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. >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 SignatureTony 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/ |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.