We have a client who manages multiple accounts for different identities under one Outlook instance. He was running into an issue where Identity 1’s name was showing up in replies sent from Identity 2. So, he’d click reply on something sent to Identity 2, Identity 2 was selected in the accounts selector at the top of the message, but in the body of the message was:
FROM: Sender <email@example.com>
TO: IDENTITY 1 <firstname.lastname@example.org>
It was a simple fix once we found it (and we looked everywhere, since Identity 1 is the name the Mac was registered to, we didn’t know where it was grabbing the name from).
There was a contact card in Outlook that had Identity 2’s email address associated with Identity 1’s name; so Outlook “resolved” the name incorrectly – instead of taking it from the account properties, like we assume it should have; it took it from the contact card.
Once we deleted the Identity 2 address from the Identity 1 contact, all was right in the world, and our replies went back to looking like:
FROM: Sender <email@example.com>
TO: IDENTITY 2 <firstname.lastname@example.org>
Quick tip: Sometimes running FIXMAPI.EXE doesn’t solve the “Cannot start Microsoft Office Outlook MAPI32.DLL is corrupt or the wrong version. This could have been caused by installing other messaging software. Please reinstall Outlook” error. If it doesn’t work for you, try renaming the MSMAPI32.DLL file to something like MSMAPI32.OLD and then restart Outlook. Office’s file protection should then copy the correct DLL into place and all would be right in the world. It’s then safe to delete the .OLD version of the file.
For English based systems, the MSMAPI32.DLL file is living in %programfiles%\Common Files\system\MSMAPI\1033 folder. Other locales will be in a numbered folder other than 1033.
We ran up against this when a client got a computer with a 60 Day Trial of Office 2007 on it, but installed their corporate version of Office 2003 over it. Uninstalling Office 2007 presented the error.
I keep coming up against this, and I keep forgetting it, so I figured I’d write it down here for all of our benefit.
Exchange 2003 allowed us to easily mail enable public folders, so something sent to email@example.com would go to a public folder where any number of staff could monitor the mailbox.
However, by default, the mail is stored in the Public Folder as a NOTE and not an E-MAIL (for the geeks in the audience IPM.POST vs. IPM.NOTE)
To make the public folder store incoming mail as emails, we need to make a quick registry change. This is all outlined in MS KB 817809.
And create (or edit) the key:
Value name: Incoming defaults to IPM.Note
Value type: DWORD
Value data: 1
Setting the value to 1 (true) stores things as IPM.NOTE (which is what we want). Setting the value to 0 sets it back to saving things as a post.
In what is becoming a series, we’ll further tweak our code to allow for filtering of the query.
In the original code, we open a query directly as a recordset. This fails if the query requires some parameters.
(I’m not going to demonstrate a way to get user input and use that as the parameter. You should be able to copy and paste the code from the original user input sections of the code and modify as needed.)
To start, let’s discuss the query and it’s parameter.
In our original code, the query was just pulling a list of email addresses. For this, let’s filter that list of addresses by domain.
Continue reading Filtering Mailing Lists using Access and Outlook
Perhaps the most popular article on the site explains how to send email to a bunch of people using Access and Outlook.
It has garnered its fair share of comments and emails, and one came in today that I figured I’d share and then elaborate on.
The mail reads (in part):
I have a following question: How to modify this module to be able to send messages to various mailing lists that I predefine in respective queries? In other words, I have in my database 3 categories of customers (in 3 different queries) andI want to address them with a different message. Do I need to create 3 macros running 3 modules each referring to a separate query with a given category of customers or is there another way to do it?
You don’t have to create modules for each list, you just need to be able to tell the macro which query you want to use before running it.
Continue reading Using Access and Outlook to Send To Mailing Lists