Access 2007-2019
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
Home   Courses   Seminars   Templates   Help   TechHelp   Forums   Contact   Join   Order   Logon  
Access Email Seminar Update
By Richard Rost   Richard Rost on Twitter Richard Rost on LinkedIn Email Richard Rost   7 years ago

Microsoft Access Email SeminarIt seems like every time I get to the point where I think I'm finished with this Access Email Seminar, I get more people asking for more features. I added a section on Email List Management yesterday. This covers putting people into various (and multiple) mailing lists.

Today, I'm going to TRY and finish this seminar up, but I've got a lot of requests from people to see:

1. Separate Mail Server Database. This is so you can set up a database on your network (or just another PC) that will sit there all day long and do nothing but process emails. Since each email in a large batch can take 3 to 5 seconds to go out, you don't want to lock up a user's workstation while it sends. The mail server database can do this for you.

2. Email to SMS Gateways. Lots of people have asked how to send text messages from the database. Well, you can do this if you know about SMS Gateways. This won't be a very long lesson, but I'll show you how to do it.

3. Collecting Email Addresses on a Web Page. Another very popular topic. I'll show you how to set up a form on your web site that people can fill out. This information will then get emailed back to you. Then...

4. Reading Email From Outlook to your Database. I'll show you how to parse through the emails in your Outlook Inbox, pull the data into your Access database, and then move the emails to a "Finished" folder in Outlook. Good stuff.

OPTIONALLY, I might cover:

5. Exporting files from an Attachment type field in your tables and sending that as an email attachment. I've only had one person ask for this so far, so if you WANT to see this, post a comment below. I personally don't recommend using Attachment data types because they cause database bloat.

OK, that's it. As you can see, I've still got a lot to cover. The seminar is already over 7 hours long, so there's a lot covered already, but if you want to learn how to send email from your database, this is definitely the seminar for you.

I HOPE to finish recording today and have the seminar up tomorrow. Unless a BUNCH of people ask me about something specific, I'm finished ADDING topics to this seminar. :)

Access Email Seminar Update Upload Images   Link 
Jerry P 
7 years ago
It not working with 64bit is a deal breaker.  I am only interested in 64bit applications, including Office 2010.

Reply from Richard Rost:

The ONLY thing that doesn't work in the entire seminar is the File Picker (where you click to select a file and it returns the filename) for attachments. Aside from that, everything else works fine. Read More...
Add a Reply
Access Email Seminar Update Upload Images   Link 
Uriel Ramirez 
7 years ago
Sometimes you have to work with evil! I would like to know how to attach files from an attachment field in a table to an e-mail. I kind of got how to attach a single one, but I have trouble to loop the process and add all attachments Read More...
Add a Reply
Access Email Seminar Update Upload Images   Link 
7 years ago
Hi Richard,

This feature would be quite useful for me as my client often sends me attachments to email as part of a bulk email shot. If you are able to slot this in - it would be fab!

Cheers,
Add a Reply
Access Email Seminar Update Upload Images   Link 
James Fisher 
7 years ago
Hi Richard
I would like to see the separate mail database server included. I would be grateful if this could be included.

Reply from Richard Rost:

Yep. It's in there. It will be with the sample Student Databases you can download. Read More...
Add a Reply
Access Email Seminar Update Upload Images   Link 
Stephen McKean 
7 years ago
Ready to go when you are Richard.
Thanks for the update.
Add a Reply
Access Email Seminar Update Upload Images   Link 
7 years ago
i Definitely interested know how Exporting files from an Attachment on a table field.
We waited so long, it would not hurt to wait a bit longer to learn about another important function :)

Reply from Richard Rost:
Add a Reply

Start a NEW Conversation
Only students may post right now. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

You may want to read these articles from the 599CD News:

9/22/2021Access DevNet Testimonials
9/20/2021Letter Writer
9/19/2021Multi Field Combo
9/19/2021Project Management
9/17/2021Overlapping Windows
9/10/2021Benefits of Access
9/10/2021Access on a Phone
9/5/2021Prevent Deletion
9/4/2021Booklet Template

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Account Login
Online Theater
Lost Password
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Customer Support
Web Site Tour
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Contact Info
Support Policy
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn
Keywords: microsoft access email seminar #msaccess  PermaLink