|
Free Lessons Courses Seminars |
TechHelp Fast Tips Templates |
Topic Index Forum ABCD |
|
||||||
|
Email Seminar Lessons Welcome to Access Email. Total running time is 11 Hours, 49 Minutes. Lessons
Resources
New 64-Bit PickFile Function
Gmail Update
Other Updates
Questions?Please feel free to post your questions or comments below. If you have questions about a specific lesson, please specify the lesson number and the time index in the lesson where the issue occurs. Thank you! Subscribe for UpdatesIf you would like to be notified whenever changes are made to this page, new lessons are posted, or comments are made, click on the subscribe button.
IntroIn this lesson you will learn how to send and receive email using Microsoft Access with and without Microsoft Outlook. We will cover how to send emails from Access, export reports as PDF files for attachments, automate bulk email, use Word mail merge, embed images, connect directly to SMTP servers, customize messages, set up mailing lists and templates, automate and track mass mailings, build an external mail server database, and import incoming email into Access tables. You will also learn how to handle attachments, collect data via email or web forms, and track deliverability and read receipts.TranscriptWelcome to the Microsoft Access email seminar brought to you by AccessLearningZone.com. I am your instructor, Richard Rost. The goal of this seminar is to teach you just about everything there is to know about sending and receiving email using Microsoft Access with and without Microsoft Outlook.We will begin by learning how to send email using Microsoft Outlook. We will learn how to export Access reports as PDF files and then attach those files to outgoing emails through Outlook. We will learn how to disable the Outlook security warning so you can send more than one email at once. We will use Microsoft Word with Access data to perform a mail merge so you can make a nice, pretty email formatted in Word and then send that out with a mail merge. We will learn how to send emails using plain text, rich text with formatting, or HTML. We will learn how to include images in emails, how to embed images in the emails themselves, and how to reference an image on a public web server. Of course, the main focus of the seminar is to learn how to broadcast large batches of bulk email. Outlook has its limitations when it comes to sending large batches of email, so we will learn how to send without using Outlook. I will show you how to connect directly to an SMTP mail server. Whoever you are using for your email account, as long as they have an SMTP address, and most of them do, we can connect directly to it using Access. I will show you how to create an email directly from a web page. This is a cool technique, especially for those of you who know a little web design. You can format a nice email right on your website and then send that directly using Access. You will learn how to embed custom merge fields in each email that goes out. This is handy for customizing the emails - you can say "Dear, first name" for example. You can include customized data in each email, such as the customer's balance. If you are worried about sending too many emails at once, I will show you how to add a send delay to your email batches. This prevents your internet provider from complaining about you sending too much email all at once and prevents a flood of traffic to your website. Spread your large email batches out over several days. We will learn how to build regular email templates. These are handy for emails that you send out on a regular basis, such as newsletters. Just select the template, select the list it's going to, add some customizations, and out it goes. I will also show you how to set up custom mailing lists so you can add each customer into one or more mailing lists. Next, we will build our own mail server database. This is a separate Access database whose job is to just sit there all day sending emails. This way, your main Access customer database is not bogged down and busy all day transmitting emails. You'll set up a batch, send it to the mail server, and the mail server will sit there all day sending emails. Everybody on your network can also connect to your mail server database to send their emails. You will still need an email account with an internet provider, but this mail server database prevents your computer from being locked up all day. Sending mail is great, but it's also nice to be able to read incoming email. I will show you how to read all of the email from your inbox in Microsoft Outlook. You will learn how to acquire that data from the incoming mail and copy certain fields into a table in Access. If you have your own website, I will teach you how you can build a form on your webpage to collect survey data. Send the customer to that webpage, they type in the data in a form, hit submit, it comes down to you via email, and then using the previous technique you can pull that right into your Access tables. If you have file attachments saved in an Access attachment field in your database, I will show you how to extract those files to your hard drive. Then you can send those out as email attachments. We will talk about tracking email deliverability and read receipts. I will explain how to send text messages using an email to SMS gateway. If your customers send you email with file attachments in them, I will show you how to extract those file attachments from Outlook and save them as files on your hard drive. I am really not kidding when I say there is a lot more in this seminar. You are going to learn a little bit of VBA programming, error handling, recordsets, SQL statements, text file input and output, timer events, Active Server Pages web programming, and lots more. Now let's talk about the prerequisites, what you should know before watching this course. You should have a good working familiarity with Microsoft Access. You should know how to build tables, forms, queries, and reports. You should know about table relationships. Basically, you should know everything that I cover in my Access Beginner Series Levels 1-9. You should also know everything from my Access Expert Series Levels 1-3. If you have not taken these courses, take a look over the outlines on my website and at least make sure you have a basic understanding of everything listed in those courses. You should have a working Microsoft Outlook account. You should have Microsoft Outlook running on your system, and you should have an email account with an internet provider. If you are not using Outlook, that is fine. You can still watch the lessons on sending email without Outlook. However, none of the lessons that require Outlook will be valid for you. This includes all the lessons on reading incoming email. I rely on Outlook as the mail program to get incoming email. Access will not process incoming email by itself. I also require that you have the 32-bit version of Microsoft Office. Now, 99 percent of everything that I show works just fine in the 64-bit version. However, some of the things like the common dialog box that we use to pick attachments will not work in the 64-bit edition. For a complete list of reasons why you should be using 32-bit Office, visit my website at the link shown and I will explain why. Now here are some things that are helpful but optional. It would be helpful if you have some prior VB programming experience. If you have taken my developer-level Access classes, my 300 series, you are just fine. I do not require that you have any previous VB programming experience. I will show you everything you need in class to be able to build the project, but you might grasp it a little better if you have some prior programming experience. Similarly, we will be doing some work with HTML emails and web pages, so a basic knowledge of HTML before taking this class will be helpful. I do have some basic HTML classes available on my website. A simple web page editor will be helpful. Microsoft has a free web editor called Expression Web; you can download it from their website. The lesson on collecting survey data from your customers using a web page requires that you have a web hosting service with a Windows server. We will be using ASP Active Server Pages to program the web submission form. This is only one lesson, so if you do not have that, do not worry about it. I will be using Microsoft Access 2013 in this class. While 99 percent of the material will work just fine in other versions of Access, I cannot guarantee compatibility with older versions. I have not tested the source code in this class with older versions of Access. However, based on my experience, most of the concepts in this class should work just fine going back to Access 2007. The one thing that I am not sure will work in the older versions is the ability to disable the Outlook Security Warning. Again, I have not tested this as I do not have older versions of Access around anymore. Check the student forum on my website to see if someone else has posted notes about using this code with older versions of Access. In any case, if you are using an older version of Access, I strongly recommend upgrading to Access 2013 as it has lots of nice new features in it. If you have questions about the topics covered in today's lessons, please feel free to post them in my student forums. If you are watching this course in the online theater on my website, you should see the student forum for each lesson appear in a small window next to the class video. Here you will see all of the questions that other students have asked, as well as my responses to them and comments that other students have made. I encourage you to read through these questions and answers as you start each lesson and feel free to join in the discussion. If you are not watching these lessons on my website, you can still visit the student forums later by visiting accesslearningzone.com/forums. To get the most out of this course, I recommend you sit back, relax, and watch each lesson completely through once without trying to do anything on your computer. Then, replay the lesson from the beginning and follow along with my examples. Actually create the same database that I make in the video, step by step. Do not try to apply what you are learning right now to other projects until you have mastered the sample database from class. If you get stuck or do not understand something, watch the video again from the beginning or tell me in the student forum and I will do my best to help you. Most importantly, keep an open mind. Access may seem intimidating at first, but once you get the hang of it, you will see that it is really easy to use. I strongly encourage you to build the database that I build in today's class by following along with the videos. However, if you would like to download a sample copy of my finished database file, you can find it on my website at accesslearningzone.com/databases. Sometimes, if you get stuck, the easiest way to learn is to tear apart someone else's database. One of the ways that I taught myself Access years ago was by tearing apart the Northwind Traders database that comes with Microsoft Access. You will find there is a sample database for each of my courses on my website. Now let's take a few minutes and go over exactly what we are going to cover in today's class. In lesson one, we are going to learn how to send email from our Access database manually using Outlook. We are going to set up a customer table, form, and report, then we will make two buttons, one to use macros and one to use VBA code, to open up a report for a specific customer that we can then send them in an email using Outlook. In lesson two, we are going to learn how to send email from Access to Outlook using the email database object macro command and the VBA send object command. In lesson three, we are going to learn how to use Microsoft Word to perform an email merge by taking our Access data, sending it to Microsoft Word, and using Word to send out a batch of HTML-formatted emails that can include colors, hyperlinks, pictures, and all kinds of good stuff. In lesson four, we are going to begin automating Outlook email using Visual Basic. We will create a form in our Access database to click one button and send an email directly to Outlook. In lesson five, we are continuing with automating Outlook email. We will learn how to send rich text and fully formatted HTML to Outlook. In lesson six, we are continuing with automating Outlook email. We will build a separate form for sending those HTML-formatted newsletters. In lesson seven, we are going to learn how to add attachments to our Outlook automated email, and we will make a button we can click on to browse for a file to make that the attachment. In lesson eight, we are going to learn how to take our Access reports, export them as a PDF file, and then use that as an attachment in the emails we are sending out. Plus, we will keep those PDF files in our attachment folder so we have a history of them. In lesson nine, we are at the lesson that everyone has been waiting for: how to send mass email to a group of people using Outlook. We are going to make a customer list form. We will be able to check little boxes on or off to determine which customers are getting their report. Then we will click one button to send reports to each of them individually as attachments using Outlook. As a bonus, I am going to teach you how to disable that annoying Outlook security warning. In lesson ten, we are going to learn how to send email to an email server without using Outlook. In lesson eleven, we are continuing to send email without Outlook. In lesson twelve, we are continuing to send email without Outlook. In this lesson, we will talk about attachments, sending to Gmail, and displaying real names in your email address fields. In lesson thirteen, we are going to finish up with the basic lessons on sending email without Outlook. This is part four. We will discuss error handling and the SMTP timeout property. In lesson fourteen, I am going to teach you how to create an email from either an HTML document that you create with Word or a web editor, or create an email by simply pulling in a web page right off the web. In lesson fifteen, we are going to begin building our bulk customized email form. In lesson sixteen, we are continuing with bulk customized email. We are going to cover variable substitutions to put your fields from your customer table into the email. In lesson seventeen, we are continuing with bulk customized email. We are going to generate email statistics like the current email number, how many emails there are, the percent completed, and we will discuss error handling, tracking, and an error log. In lesson eighteen, we are continuing with bulk customized email. We are going to set up a send delay so you can put a delay between emails so you don't flood your email server. We are going to set up an Abort and Pause checkbox so you can pause the batch in the middle or abort the batch, and better control when the emails go out. Sometimes you are going to want to send the same email to the same group of people on a regular basis. So in lesson nineteen, we are going to make a template form where you can put in all the details for the email, including the source, which customers are getting it, the default subject and body, and then automatically send that to your bulk email form. In lesson twenty, we are finishing up with our bulk customized email sender. We are going to see how to put a sending message up when the email server is actually connecting to your SMTP server, and we will see how to import an HTML file directly into your text editor. In lesson twenty-one, we are going to cover mailing list management. We are going to set up a mailing list table so you can have different lists with different customers on each list. We will create a subform on our customer form so you can pick which lists each customer is on. Then we will add those mailing lists into our email templates. Tying up your customer database all day long while you are sending a large mail batch is no fun. So in this lesson, we are going to begin building an external mail server database, another copy of the email database, and its function will be to just handle sending emails all day, while it frees up your customer database for you to work in. In lesson twenty-three, we are continuing with building your own external mail server database. In lesson twenty-four, we are finishing up building your own external mail server database. In this lesson, we are actually going to separate the two so you can run the mail server in a separate database window on your computer in the background, or on a different machine that you can set up as your mail server. In lesson twenty-five, we are going to cover reading email from our Outlook inbox into our Access database. In lesson twenty-six, we are going to learn how to collect data via email. We are going to send out an email to a list of people with instructions to just type the responses in the email and send it back to us. Then we will have our Access data pull that out of Outlook, extract the fields that they typed in, and save it to a table in our database. In lesson twenty-seven, I am going to show you how to set up a real simple web-based form on a web server where you can collect data from users there, have that submitted via email to you, and then you can use the previous lessons to pull in that data from Outlook. In lesson twenty-eight, I am going to teach you how to extract files that might have been saved in an attachment field in your database tables, save those as files on your hard drive, and then you can use those files as attachments in your emails. In lesson twenty-nine, we are going to cover some minor topics that people emailed in and wanted to see. We will talk about delivery status notifications and read receipts. We will talk about email to SMS gateways where you can send text messages via email to people's cell phones. I will show you how to extract attachments from incoming emails and save them as a file on your hard drive. QuizQ1. What is the main focus of this Microsoft Access email seminar?A. Teaching basic Access table design B. Learning to create web pages in Access C. Sending and receiving email using Microsoft Access with and without Outlook D. Managing SQL Server databases Q2. Which software is NOT specifically discussed as part of the seminar topics? A. Microsoft Outlook B. Microsoft Word C. Google Sheets D. Microsoft Access Q3. Why is it important to learn how to export Access reports as PDF files and attach them to emails? A. PDF files cannot be edited B. So you can include reports as attachments in outgoing emails C. So you can print the reports directly D. Because PDF is the only format Access reports support Q4. Which of the following email formats will be covered in the seminar? A. Only plain text B. Only plain text and HTML C. Plain text, rich text, and HTML D. Only HTML Q5. What is one reason to use a direct SMTP server connection instead of Microsoft Outlook? A. To enable handwriting recognition B. To avoid Outlook's limitations with sending large batches C. To synchronize with Google Calendar D. To import Access data into Excel Q6. What does adding a "send delay" to email batches help you accomplish? A. Increase email speed B. Prevent complaints from your internet provider and reduce network congestion C. Enable automatic Outlook startup D. Backup your database Q7. What is the purpose of building regular email templates discussed in the seminar? A. To create backup copies of your emails B. For emails sent out regularly, like newsletters C. To manage SQL queries easily D. To automate printing of reports Q8. Why would you build a separate "mail server" Access database? A. To keep your main customer database free while emails are sent B. To increase database size C. For automatic table indexing D. To host web pages Q9. Which of the following is needed to read incoming email into Access as shown in the seminar? A. Google Drive B. A working copy of Microsoft Outlook C. Only Access and Excel D. OneDrive synchronization Q10. What is a prerequisite before taking this seminar? A. Mastery of Visual Basic B. Working knowledge of Access tables, forms, queries, and reports C. Expert knowledge of SQL Server D. Certification in HTML5 Q11. What is REQUIRED for using all lessons involving reading incoming email? A. Gmail web login B. Microsoft Outlook installed and configured C. Access 64-bit only D. A mobile phone Q12. Why does the instructor recommend using the 32-bit version of Microsoft Office? A. 64-bit Office cannot run any Access applications B. Some features, like common dialog boxes for attachments, do not work in 64-bit C. 64-bit versions are always slower D. Microsoft does not support Outlook on 64-bit Q13. What should you do if you get stuck or do not understand something from the video? A. Give up and skip to the next lesson B. Watch the video again or ask questions in the student forum C. Only send an email to Microsoft support D. Try continuing with unrelated projects Q14. In the lessons, how is variable substitution in bulk-customized emails used? A. To add random characters for security B. To insert database fields like first name or customer balance into emails C. To compress attachments D. To encrypt outgoing messages Q15. What technique does the seminar teach for tracking email deliverability and read receipts? A. Using a VPN B. Using delivery status notifications and read receipts C. Sending multiple copies of each email D. Encrypting all emails with SSL Q16. Which programming topics will students be exposed to during the seminar? A. Only SQL Server performance tuning B. VBA programming, error handling, recordsets, SQL statements, and more C. Basic Android app development D. Blockchain programming Q17. What is the instructor's recommendation for the best way to learn from the course videos? A. Apply new material to your actual company projects immediately B. Traverse the lessons at random C. Watch each lesson through once, then follow along step by step D. Only read the transcript, skip watching the videos Q18. What is the purpose of the sample database made in the lessons? A. To upload your customer data for grading B. To give you a working example that you can follow along with and dissect C. To serve as the company email server D. To backup Outlook messages Q19. Which of the following is an OPTIONAL but helpful prerequisite for the class? A. Prior VB programming experience B. Experience as a Windows System Administrator C. Microsoft SQL Server certification D. Understanding of blockchain technology Q20. For the lesson on collecting survey data using a website, what type of hosting is required? A. Any Linux web server B. Windows hosting with ASP support C. Google Forms only D. No hosting, just Excel Answers: 1-C; 2-C; 3-B; 4-C; 5-B; 6-B; 7-B; 8-A; 9-B; 10-B; 11-B; 12-B; 13-B; 14-B; 15-B; 16-B; 17-C; 18-B; 19-A; 20-B DISCLAIMER: Quiz questions are AI generated. If you find any that are wrong, don't make sense, or aren't related to the video topic at hand, then please post a comment and let me know. Thanks. SummaryToday's video from Access Learning Zone covers everything you need to know about sending and receiving email using Microsoft Access, both with and without Outlook. I am Richard Rost, your instructor, and my goal is to provide you with a thorough understanding of managing email directly from Access.We start by learning how to send email through Microsoft Outlook. You will see how to export Access reports as PDF files and attach them to outgoing emails. I explain how to disable the Outlook security warnings so you can send multiple emails at once without interruptions. We will also use Microsoft Word with Access data to perform a mail merge, allowing you to create well-formatted emails using Word templates and send them in bulk. The seminar covers sending emails in different formats: plain text, rich text, and HTML. We will look at how to include images in emails, whether by embedding them in the message or referencing them on a public web server. A primary focus is on broadcasting bulk emails, which is where Outlook sometimes falls short. When you need more capacity, I show you how to connect Access directly to an SMTP mail server. This method works with most email providers, as long as they offer an SMTP address to connect to. You will learn how to build emails directly from a web page, which is especially useful for those with web design experience. This lets you create a customized email on your website and send it directly using Access. I cover using merge fields to personalize each bulk email, adding information such as the recipient's first name or their account balance. If you're concerned about sending too many emails at once, I'll show you how to add a delay between outgoing emails. This prevents issues with your internet provider and avoids overwhelming your web server. You can spread large email batches out over several hours or even days. We will build reusable email templates, which are perfect for recurring messages like newsletters. You'll see how to select a template, pick a mailing list, add custom adjustments, and send it out easily. I also explain how to manage custom mailing lists, letting you assign each customer to one or more groups. A key project in this seminar is building a dedicated mail server database using Access. This database will handle the email sending process, allowing your primary customer database to remain responsive and free for other work. Once you've set up a batch, you send it to the mail server database, which runs in the background and transmits the emails. Anyone on your network can use this centralized mail server. Keep in mind that you still need a regular email account from your provider, but this system keeps your daily work from being interrupted by large email sends. It's important to be able to receive email as well, not just send it. I'll show you how to read messages from your Outlook inbox and store important information from those emails into Access tables. For those with a website, I'll explain how to create a form on your site to collect survey data. Customers fill out the web form, the results are sent via email, and Access can automatically import the data using previous techniques from this course. I cover how to manage file attachments, both sending and receiving. If you have files saved in Access attachment fields, I show you how to extract those to your computer so you can send them as email attachments. We will discuss tracking email deliveries and read receipts, and I'll explain how to send text messages by using an email-to-SMS gateway. If you receive emails with attachments, I demonstrate how to save those files from Outlook to your hard drive. Throughout the seminar, you'll also learn some VBA programming, error handling, working with recordsets, writing SQL statements, performing file input and output, using timer events, doing basic Active Server Pages (ASP) programming, and more. Before getting started, you should already be comfortable with Microsoft Access. You need to be familiar with creating tables, forms, queries, and reports, and you should understand table relationships. Ideally, you've completed my Access Beginner Series through level 9 and Expert Series through level 3. If not, please look at the course outlines on my site and make sure you've covered those basics. You will also need Microsoft Outlook set up and working, along with an email account from a provider. If you don't use Outlook, you can still benefit from the sections on sending email without Outlook, but keep in mind you won't be able to follow the lessons on reading incoming email, since Access relies on Outlook for that functionality. I recommend using the 32-bit version of Microsoft Office. While the majority of my examples work fine in the 64-bit version, there are some key features, such as the dialog box for selecting attachments, that do not work in 64-bit Office. You can find more details about this on my website. While previous VB programming experience is helpful, it isn't required. If you have taken my advanced Access developer classes, you'll be comfortable with the code sections. Regardless, I introduce the necessary programming skills step by step. Similarly, while a basic understanding of HTML will be helpful for parts of the course dealing with web pages and HTML emails, it is not required. Free web editors like Microsoft Expression Web can make things easier. Collecting survey data by web form requires a hosting provider with a Windows server to use ASP. This is just one lesson, so if you don't have this setup, you can still benefit from the rest of the seminar. All lessons are demonstrated in Access 2013. Most of the material will work in newer versions and should work for Access 2007 or later, but I haven't tested every feature, especially the Outlook security warning bypass, with older versions. You can check my student forums for updates from other users about compatibility. If you are using an older version of Access, I recommend upgrading to Access 2013 for all the new features and improved experience. If you have questions during this seminar, I encourage you to post them in the student forums. On my website, each lesson includes a forum where you can see questions from other students and my responses. Use these discussions to enhance your learning and feel free to participate. For the best results, I advise watching each lesson all the way through before trying to replicate the examples. After the first viewing, go back and work along with me, building the sample database step by step. Focus on the class project first before applying the ideas to your own databases. If you run into trouble or find something unclear, rewatch the video or reach out in the forums for help. Access can seem overwhelming at first, but with practice, you will find it increasingly user-friendly. I recommend building the example database along with me. If you prefer, you can download my finished sample files from my website to examine how everything works. Breaking apart a complete project is often a fast way to learn, just as I learned from the original Northwind Traders database in Access. Here's an overview of what today's class covers: Lesson one introduces sending emails directly from Access using Outlook. We set up a customer table, form, and report, then add buttons for sending reports for individual customers via Outlook, both using macros and VBA. Lesson two explains sending emails from Access to Outlook through the email database object macro and the VBA SendObject command. Lesson three demonstrates performing a mail merge using Microsoft Word and Access data to send personalized, HTML-formatted bulk emails. Lesson four starts automating email in Outlook with Visual Basic by creating Access forms that send emails with the click of a button. Lesson five covers sending formatted rich text and HTML emails through Outlook automation. Lesson six expands on Outlook automation with a dedicated form for HTML-formatted newsletters. Lesson seven details adding attachments and creating a button to select files to attach to outgoing messages. Lesson eight shows how to export Access reports as PDF files and use these documents as attachments in your emails, while also maintaining a history of sent files. Lesson nine focuses on sending mass emails to selected customers using Outlook. You learn to pick which customers receive messages and send out reports in bulk as attachments. As a bonus, I include instructions to turn off the Outlook security warning that often appears during mass email sends. Lesson ten introduces sending email directly to an SMTP email server without going through Outlook. Lessons eleven through thirteen continue teaching about sending email without Outlook, including how to send attachments, support for sending to Gmail addresses, displaying real names, error handling, and managing SMTP timeouts. Lesson fourteen covers creating HTML emails using Word, a web editor, or by pulling content directly from a live web page. Lessons fifteen through eighteen walk you through building a bulk customized email sender. You learn how to perform variable substitutions to personalize each email, create email statistics to track progress, and add send delays, abort, and pause controls for batch sending. Lessons nineteen and twenty cover setting up templates for reusable emails and finishing the bulk email sender, including how to display sending messages and import HTML files. Lesson twenty-one deals with mailing list management, teaching how to assign customers to lists and connect those lists to predefined email templates. The impact large batches have on your main database is addressed in lesson twenty-two, where we start building an external mail server database dedicated to sending, freeing up your primary database for business as usual. Lessons twenty-three and twenty-four complete this mail server project and explain how to run it separately, even on another computer if needed. Reading incoming emails into Access from your Outlook inbox happens in lesson twenty-five. Lesson twenty-six introduces collecting data via email by sending out questions to recipients and automatically importing their responses into Access. Lesson twenty-seven explains creating web-based forms for collecting user data, sending it by email, and processing the information with Access. Lesson twenty-eight teaches extracting files from Access attachment fields and sending them as email attachments. Finally, lesson twenty-nine covers delivery status notifications, read receipts, using email-to-SMS gateways for text messages, and saving attachments from incoming emails. For a complete video tutorial with step-by-step instructions on everything discussed here, visit my website at the link below. Live long and prosper, my friends. Topic ListSending email from Access using OutlookExporting Access reports as PDF and emailing Disabling the Outlook security warning for bulk email Using Microsoft Word with Access data for email mail merge Sending plain text, rich text, and HTML emails Including and embedding images in emails Referencing web-hosted images in email Broadcasting large batches of bulk email Limitations of Outlook for bulk email Sending email from Access without Outlook via SMTP Connecting Access directly to SMTP mail servers Creating emails from web page content Embedding custom merge fields in emails Customizing emails with customer data Adding send delays to large email batches Building reusable email templates in Access Setting up and using custom mailing lists Building an external mail server Access database Separating mail server from main customer database Reading incoming email from Outlook inbox into Access Extracting data fields from incoming email to Access tables Building web forms to collect data for email import Extracting attachments from Access attachment fields Attaching extracted files to outgoing emails Tracking email deliverability and read receipts Sending text messages via email to SMS gateways Extracting file attachments from incoming Outlook emails Automating sending emails with Access macros and VBA Using the EmailDatabaseObject macro command Using the VBA SendObject command Automating Outlook email with Visual Basic Sending HTML-formatted newsletters via Outlook Adding attachments with file browser to Outlook emails Exporting Access reports as PDF for email attachments Sending mass email with Outlook to selected customers Sending email to Gmail and handling real names Handling SMTP errors and timeouts in Access Creating emails from HTML documents or web pages Building a bulk customized email form in Access Variable substitution in bulk email generation Generating email send statistics and error logs Implementing send delay, abort, and pause for bulk email Managing and assigning mailing lists in Access Importing HTML files into Access email editor |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
| |||
| Keywords: Access Email Seminar PermaLink How To Send, Receive, and Automate Email With Attachments and Mail Merges in Microsoft Access |
