Re: Importing with "do not import duplicate items" based on 1 crit

Thank you guys.

Seems I need to clarify few things. First, it's a problem facing a friend of
mine, not me. He emailed me asking for a solution, and he doesn't speak
English. Second, my friend receives every other day a list of fax numbers in
an Access file. The sender sets the fax numbers column as "primary key" with
"no duplicates" so that he won't have duplicates, but he sends sometimes fax
numbers already sent few days ago under a different name.

Dear Russ, I'm not sure what you meant when you said, "Outlook does not
integrate with any fax software that supports 'sending faxes to many, many
contacts'". The Fax feature in Win XP (at least) does it.

Dear Karl, thanks for your suggestion. I translated it to my friend and sent
it to him. Waiting foe his updates.


"Karl Timmermans" wrote:

Something about this question doesn't compute. If you have more than one
contact with the same business fax number (one or more in the Outlook
contact folder along with one or more in the Access file - how is the
"primary" contact determined in terms of information for the purposes of
sending a fax (or is this intended to simply be a receipent agnostic general
fax broadcast? That aside.....

For the purpose of this response - will assume that what you want at the end
of the exercise is a contact folder of unique business fax numbers where no
other info is really important or relevant. ContactGenie DataPorter does
have an option that would deal with this but really depends on what the
answers were to the original questions above so not going to suggest it as a
viable option/solution at this point (and don't know of anything else that
would do what you want).

Instead, you may want to consider this (there are different ways to do the
same thing - this is just one quick and dirty approach):

#1 - Export the contact folder with minimal info (Bus Fax# field is all you
need) (pick whatever output file format - csv/xls/mdb)
#2 - In your Access database - create a new table via a customized "Make
Table" query extracting only unique BFax #s - (SELECT UNIQUE BFax# INTO
<NewTableName> FROM <SourceTable>)
#3 - In this same database - import the file created in Step #1
#4 - Combine tables from step #2 (NewTable) & 3 (via a simple Access Append
query)
#5 - Repeat Step #2 changing Table names in a new <Make Table> query
(if you want more info beyond BFax# - can be easily generated with a couple
of additional Access steps or alternatively you can create a new table of
records with BFax'#s not in the Outlook contact folder with a little Access
query creativity once you have the file from step #1)

At the end of #5 - you will have a table of totally unique BFax#'s which you
can than import into a new Outlook contact folder consisting of contact
items with unique Bus Fax #s

Karl

___________________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2007"
http://www.contactgenie.com




"James" <James@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9544F5EA-7495-4A99-9825-674D09769676@xxxxxxxxxxxxxxxx
Hi

I need to import a long list of fax numbers in an Access file to Outlook
in
order to simplify sending faxes to my many, many contacts (this way I can
select the whole Outlook contacts in the fax wizard instead of entering
numbers one after the other). Outlook Contacts already contains fax
numbers.
Unfortunately, the Access file contains some of the same fax numbers but
under different names. Is there a way to import the fax numbers from
Access
while opting for not importing duplicates of "Business Fax" only?

Thanks



.

Relevant Pages

  • Re: Importing with "do not import duplicate items" based on 1 crit
    ... The vast majority of end users have found that Windows XP Fax does not support sending to more than just 2 or 3 recipients at a time, ... Dear Russ, I'm not sure what you meant when you said, "Outlook does not ... contact folder along with one or more in the Access file - how is the ... of the exercise is a contact folder of unique business fax numbers where no ...
    (microsoft.public.outlook.contacts)
  • Re: Importing with "do not import duplicate items" based on 1 criterio
    ... of the exercise is a contact folder of unique business fax numbers where no ... records with BFax'#s not in the Outlook contact folder with a little Access ... I need to import a long list of fax numbers in an Access file to Outlook ...
    (microsoft.public.outlook.contacts)
  • Re: Loop Attachment (once again)
    ... Sorry about the confusion - I am using MS Outlook 2007. ... I need to send some files to friend of mine which is ... about 50 MB but provider doesn't let emails through that have attachments ... all files in a folder). ...
    (microsoft.public.outlook.program_vba)
  • changing Save As folder.
    ... I have a friend who recently started using Outlook Express. ... to be able to change the Default Save As folder from My Document to one of ... would think that would be a standard feature. ...
    (microsoft.public.windows.inetexplorer.ie6.outlookexpress)
  • Re: Importing PSD fails
    ... I created a folder under the outlook folder, and copied the backed up .PSTto ... Opening the old .PST, that resulted in a second occurance of the top-level ... friend 1 ...
    (microsoft.public.outlook.general)
Loading