Holiday Greeting Card Mailing List Database

Yes, I know this video is from 2021. It's an oldie but a goodie. Enjoy!

In this video, I will show you how to track your Christmas Card list in Microsoft Access. We will modify my free customer database so you can see who is on your list. We'll make mailing labels for the people on the list. We'll use an update query to track the last date we sent cards out to each person, and we'll use an append query to put a note in their contact history so you can see all of the times in the past you've sent them cards. 

Cassidy from Lakewood, Ohio (a Platinum Member) asks: What's the best way to track my Christmas Card list in Access? I like to keep track of who is getting a card this year, when the last time I sent them a card was, when the last time they sent me a card was, and of course it would be nice to actually print the labels from inside of Access.

Members

Members will see how to create different greetings for card recipients, such as Joe Smith, Joe & Sue Smith, Joe Smith & Sue Jones, The Smith Family, or whatever else you'd like. You can customize the greeting for each recipient. We'll also use conditional formatting to easily see who is missing address data.

•  Extended Cut Video - Silver
•  Database Download - Gold

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Links

• Query Criteria: http://599cd.com/Criteria
• Intro to VBA: https://599cd.com/IntroVBA
• Update Query: https://599cd.com/UpdateQuery
• Append Query: https://599cd.com/AppendQuery
• Mailing Label Seminar: https://599cd.com/MailingLabel
• Holiday Greeting Cards Template: https://599cd.com/HGCT

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Holiday Cards, Christmas Cards, Hanukah Cards, Kwanzaa Cards, Festivus Cards, Solstice Cards, christmas card database, xmas card database, holiday cards, address labels, print christmas cards, christmas card list, address book, create Your Own Christmas Card Database Tutorial, christmas card template, Hanukkah cards, Kwanzaa cards, business holiday cards, How do you print Christmas cards at home