Exporting Access Contacts to a Outlook Public Folder
How to export contacts from an Access table to an Outlook folder.Q: Farouk Dawood has written code to export contacts from an Access table to an Outlook folder, using the CreateItem(olContactItem) syntax, but it isn’t working – the new contacts are being created in the default local Contacts folder instead. What is the syntax for […]
Synchronizing Access and Outlook
How to synchronize Access and Outlook – a more advanced lesson. Q: Jim Brooking writes that he is trying to use my Code Sample #49 for synchronizing Access and Outlook contacts, but it doesn’t do all that he wants, in particular two-way synchronizing. A: My Code Sample #49 dates from about 10 years ago, when […]
Sending Outlook Attachments
Q: Sanjay Singal wants to know how to send an attachment generated from Access data in an Outlook email message. A: Access Archon #148 deals with this topic (creating and mailing attachments in an email message). In this sample database, the values of various email message fields are picked up from a form. See Also […]
Making Outlook ‘Office Watch’ friendly
How to ensure Access Watch isn’t mistakenly marked as spam in Outlook. Sometimes Office Watch newsletters end up in the Junk Email folder, it might seem like a conspiracy by Microsoft but it’s probably not. You can tweak the Outlook spam filter to ensure Access Watch isn’t mistakenly marked as spam — but it’s not […]
Exporting Table Information to an Outlook Calender
Here’s a simple procedure for exporting information from a table to an Outlook calendar. Q:Elizabeth Moeck wants to know if class name and date information stored in an Access table can be exported to an Outlook calendar A:Here is a simple procedure that does this: Dim dbs As Database Dim rst As Recordset Dim appOutlook […]
Viewing an email message header in Outlook
How to view the ‘raw’ email message header in Outlook. Most of the time all you need is the basic message information – From, To and Subject but occasionally you need to dig a bit deeper into the ‘raw’ email message header. Here’s how to do it in Outlook 2007, Outlook 2003 and before. click […]
Matching Outlook and Access Contacts
How to synchronize Access and Outlook contact data. Access Archon #145 Introduction If you store contact data both in an Access table and an Outlook Contacts folder, it would be handy to be able to quickly switch from the Access contact record to the Outlook contact item, or vice versa. In this article I show […]
Mass Emailing of Report Links, Part 2
Access Archon #170 Before we finish this article a reminder that mass emailing should always comply with all local laws. More generally, you should ensure that all mailings are to people who have authorized the use of their email address for that purpose. Our purpose is to help you efficiently send emails from Access – […]
Removing attachments from your saved messages in Outlook
Here’s how to trim down your Outlook storage by removing attachments from messsages, without deleting the message itself. click here for more …
Mass Emailing of Report Links, Part 1
Access Archon #170 Introduction Several earlier Access Archon articles have dealt with various aspects of mass emailings. In Access Archon #106 I described how to send mass emailings from an Access table, in Access Archon #135 I described how to send reports as attachments for a mass emailing, and in Access Archon #148 I described […]
Exporting an Appointment from Access to Outlook
How to export information from a current record of an Access form to make a new Outlook appointment. Q: Martin Wichmand writes: “In my planner I have a Subject, Startdate, StartTime and Endtime. Normally I import those to Outlook via the slow and manual way. But I wonder if it is possible to send those […]
Sending a Christmas email
It’s too late for Christmas cards but not too late for a simple Xmas Email. We’re the first to admit that sending a Christmas email isn’t the most traditional method but it can be done with good cheer and grace. Here’s just one example from a friend and some tips from the writer and designer […]
Easy invitations in Outlook
How to easily make appointments with other people using Outlook. Outlook has some great features for making appointments and sharing those details with others. The main features can be used by anyone to setup dinner, movies or any personal event. Outlook lets you create an appointment in your calendar then email the details to other […]
Outlook 2010 – early impressions
The most noticeable changes in Office 2010 are in Outlook and, sad to say, they aren’t all for the best. Some early notes and first impressions based on the most recent beta release of Outlook 2010. The most noticeable changes in Office are in Outlook 2010 and, sad to say, they aren’t all for the […]
How NASA Runs Microsoft Outlook From Space — and Why It Works
When the Space Shuttle Atlantis orbits Earth, its crew checks email using something you probably have on your own desk right now: Microsoft Outlook. NASA runs a stripped-down version of Outlook 2003 on standard laptops in orbit, powered by Exchange Server, but with a twist that no office on Earth would recognize. Instead of a […]
Clever Outlook Contacts on Kindle
Our popular Outlook guide is now available for Kindle device and Windows software. We’re delighted to announce the release of our Clever Outlook Contacts book on Amazon for worldwide distribution on your PC or Kindle device. It’s the same ebook as we’ve sold to thousands of people over the years, complete with full color images […]
