I have an Access file that has over 500 contacts in it. Several times a year,
I want to send this information to multiple users across the nation. They
already have these contacts in Outlook. What I'm looking to do is find a way
that they can override the existing contact with the new contact information.
There is already a duplicate contact finder in Outlook, but that uses the
"File As" field as the comparison. My issue with that is the names often
change (married so last name changes, death of spouse, etc.).
Things I'm looking for as options:
1) VBA code or macro that would compare a specified field (I have unique
contact ID in a field for this) and update just like the existing duplicate
contact finder instead of the "File As" field.
2) Program that would do this. I don't want close to 50 people have to pay
for a program is I can help it.
3) Any other suggestions/ideas.
I can either send the contacts to the other users as an Excel file, Access
file, .pst file and have them import into a temporary folder and then merge,
or basically any other way possible.
I am using Access 2007, Outlook 2007, Windows XP.
I've inquired on an Access forum and no answer, so thought I'd try here as
Message posted via OfficeKB.com
||6/6/2010 1:02:57 AM
(page loaded in 0.015 seconds)
12/3/2013 3:39:08 AM
Merging Contacts - microsoft.public.windows.live.mail.desktop ...
Hi guys I was wondering if anyone has idea on how to merge my contacts that have duplicates. ...
customize my contact form - microsoft.public.outlook.contacts ...
Hi I want to customize my contact form in outlook 2007. I have over a 1000 contacts. What I want to do is just add name, and addresses for a mail merge.
Mail merge limits for print documents - microsoft.public.word ...
I use mail merge to print mailers for customers (Outlook contacts /Word Document). These are not emails, just going to the printer. The documents ...
Adding Clients with 2 different names to Contact - microsoft ...
Is there a way to enter a client into Outlook Contacts when both husband and wife have 2 different last names? I've tried to do a mail merge and pr...
Outlook: How to add Dear (contact first name) in a CCd mail ...
I would like to send a cc email to many people, and the body of the mail use their First name (the contacts are in an outlook file) So basically it's just merging the ...
Mail merge using Windows Live Mail - microsoft.public.publisher ...
Mail Merge labels using Contacts from Windows Live Mail ... I am trying to set up MailMerge for labels using my Contacts folder from Windows Live Mail, which is my e-mail ...
Mail Merge - Insert Address Block - Insert Country - microsoft ...
> You can use If statements to get rid of the spaces - but the country > should populate if it exists in the contact. > > Are you starting the merge from outlook or word?
Publisher e-mail merge fails - microsoft.public.outlook.general ...
I have Publisher 2007 and Outlook 2007. Created an e-mail merge newsletter with Access and Outlook contacts database. Goes through whole routine to ...
microsoft.public.outlook.contacts - page 2
how to permanently set fields in contacts? Utf 1 249 is there a way to permanently set the fields in contacts? For example, the phone fields, I'd like to have them in ...
Exporting Outlook Contacts to csv file but does not work ...
On 3/21/2010 8:27 AM, Mully wrote: > To Gordon; > > So, If I mail merge from a list under my list of contacts and mail merge > from that list, will the emails I send ...
How to Merge Contacts | eHow.com
At times, you may notice your contact list is overcrowded with duplicate names. If that is the case, you can easily remove these duplicates and merge the contact ...
Merge Gmail Contacts - Google Operating System (Unofficial Google ...
The feature is not yet automatic, so you need to find the contacts you want to merge, but it's useful if you don't have too many duplicates. Just select ...
Merging contacts - Gmail Help
Gmail Help Merging contacts If you have duplicate contacts, there are two ways you can fix this problem: merge your contacts manually, or have the system find and ...
How to Merge Outlook 2007 Contacts | eHow.com
Merging contacts from your Microsoft Outlook 2007 software is a simple process that can save you a significant amount of time and energy when done properly. There ...
Outlook--Merging Contacts Without Duplication7/28/2012 1:40:47 PM
Here’s how you can merge contact lists but separate them into categories.