Outlook Connector update bug
If the update for Outlook connector 14 to Hotmail breaks down, there’s a fix.Microsoft released a mandatory upgrade to its Outlook Connector 14 software which endlessly cycles through the “You must upgrade…” message. It seems to affect Vista and Windows 7 users leaving XP systems alone. The upgrade was offered automatically via Microsoft Update so […]
64-bit Office – is it worth the trouble?
So much for the difficulties of 64-bit Office 2010 – is it worth it? Last week we had a lot of coverage on Office 2010 64-bit edition, the compatibility issues and special installation requirements. If you don’t think you’ll have any compatibility problems, is it worth the trouble? That’s the big question – certainly 64-bit software […]
Outlook 2010 – calendar preview of appointments
Another little change in Outlook 2010 is the way an incoming appointment request is displayed. Outlook has a great feature where people can email an appointment to you and you can respond with the details automatically added to your calendar. In Outlook 2007 you see the details of the appointment plus a small text warning […]
Outlook 2010 – Save As Picture
A long desired feature finally appears in Outlook 2010. Sometimes it’s not the ‘headline’ features in new software that really appeal – it’s the small changes that make a big difference. The downside of these innovations is that you wonder why Microsoft took so long to make a simple change. For years people have wanted […]
Outlook spam filter update
March update to your Outlook junk email filter. Just a reminder that Microsoft now updates the spam filter in Outlook 2007 more often, with the latest released on 9 March 2010. You can download it from Microsoft or it may arrive via Windows/Microsoft Update. The update should help Outlook better tell the difference between spam […]
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 […]
Finding Outlook mail messages from a specific sender
How to find Outlook mail messages from a specific sender. Q: Ray in New Zealand writes: “I’m trying to link my Access db (Accommodation) to Outlook. I receive accommodation bookings from guests and would like to be able to click on a button on the guest data form which will take me to the emails […]
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 […]
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 […]