This course is designed for those interested in learning about how to use Microsoft Access and Outlook to automate distribution of Excel files.
Read more.Instructor
Hello, my name is Bruce. I am a self-employed Access programmer and general computer consultant to small and medium-sized businesses. I got into programming because I was tired of all the jargon most programmers use and how they don't seem to care about business. "Technology is great but I've always been more interested in how it can be used to make companies more profitable." - Bruce I live in Portland, Oregon and have many long-term relationships with local businesses. Many of the sy
Access all courses in our library for only $9/month with All Access Pass
Get Started with All Access PassBuy Only This CourseCourse Curriculum
Section 1 - Overview And Email Setup | |||
Introduction And Overview Of Files | 00:00:00 | ||
Create A Free Inbox.Com Email Account If Necessary | 00:00:00 | ||
Setup Outlook To Send Emails | 00:00:00 | ||
Section 1 Notes | 00:00:00 | ||
Section 2 - Setup The Course Files And Update The Link To Excel | |||
Links To Course Files | 00:00:00 | ||
Test The Access Macro And Setup The Email List | 00:00:00 | ||
Update The Data Connection Between Access And Excel | 00:00:00 | ||
OFFICE 2010 Data Connection Instructions | 00:00:00 | ||
Section 2 Notes | 00:00:00 | ||
Section 3 - Create A VBA Function To Prepare The Excel File For Emailing | |||
Create A New VBA Module And Link To Excel And Outlook References | 00:00:00 | ||
Create A VBA Function That Will Prep The XL File | 00:00:00 | ||
Setup Variables In The New Function | 00:00:00 | ||
Add VBA Code To Check Existence Of Excel File | 00:00:00 | ||
Get The Send File Name And Copy The Excel File | 00:00:00 | ||
Open Excel, Refresh Data And Remove Connections | 00:00:00 | ||
Using The WAIT Function And Office 2010 Modifications | 00:00:00 | ||
Save And Test The PrepXL VBA Function | 00:00:00 | ||
Section 3 Notes | 00:00:00 | ||
Section 4 - Create A VBA Function To Send The Email | |||
Create The DoEMail VBA Function And Setup Variables | 00:00:00 | ||
Get The Email Subject And Body And Link To Outlook | 00:00:00 | ||
Setup The Email List Table And Our Loop | 00:00:00 | ||
Setup The Message To, Subject And Body | 00:00:00 | ||
Setup The Email Attachment And Send The Message | 00:00:00 | ||
Last Touches To Finish The DoEmail Function | 00:00:00 | ||
Test The Finished Email Function | 00:00:00 | ||
Add The Function To The Macro And Do The Final Test | 00:00:00 | ||
Section 4 Notes | 00:00:00 | ||
Section 5 - Conclusion | |||
Final Overview And Future Additions | 00:00:00 | ||
Section 6 - Email A PDF Copy Of A Report From The Report Itself! | |||
Download Link For This Section’s Database | 00:00:00 | ||
Overview Of The New Database | 00:00:00 | ||
Modify The Do Invoice Button | 00:00:00 | ||
Fix Problem With Subtotal On Report | 00:00:00 | ||
Create A Close Button On The Report | 00:00:00 | ||
Create An Email Invoice Button | 00:00:00 | ||
Create A New Subroutine To Create The PDF File | 00:00:00 | ||
Test The PDFName And Get The Email Address | 00:00:00 | ||
Create The PDF File And Test The Subroutine | 00:00:00 | ||
Create A New Subroutine To Do The Email | 00:00:00 | ||
Finish The Email Subroutine | 00:00:00 | ||
Final Touches And Testing | 00:00:00 | ||
PDF Of Our Two Subroutines | 00:00:00 |