Trying to maintain data in two locations is a recipe for inaccuracies. Why not keep data in Outlook and either select the items one-by-one or select them using a category? You can then write code in Outlook VBA that uses Application.ActiveExplorer.Selection to iterate the selected items and create an individual message to each recipient. That's far more likely to get through any spam filter than sending a Bcc message.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"George" wrote in message ...
Thanks a lot Sue for your prompt reply,

1. I have a lot of contacts in my Outlook contacts. I need to choose some
of them in order to send them a file (document file - promotional parts)
every now and then - the file will be the same for all recepients. In some
cases I may choose more and in some cases less contacts - most of the will be
the same.

2. I don't want them (the recepients) to see the rest of the recepients -
that is why I need them all in the bcc.

3. I thought that it would be much better if I have those contacts in an
Access database, so using a query to select, when I want, to whom the e-mail
will be sent.

Is it clear now? Any ideas will be highly appreciated.

Thanking you once again,

GeorgeCY

Ο χÏ�ήστης "Sue Mosher [MVP-Outlook]" Î*γγÏ�αψε:

3) I don't understand. Why would you use Bcc on a mail merge to send a separate file, rather than attaching it as part of the code for the mail merge? That, after all, is the whole point of the given code sample. Maybe you should give us a better picture of what you're trying to do. The code sample you've chosen might not be the right one.

"George" wrote in message ...
Dear Sue,

What I need is the following:

1) I have a MS-Access database containg contacts info.
2) I need to have a mail merge document in order to send the same letter
(e-mail) to all my contacts.
3) I need to send a separate (preferably using the bcc of MS-Outlook) e-mail
with an attached file (the same file for all contacts).

How can I accomplish that using the guidelines of the given VBBA?


Ο χÏ�ήστης "Sue Mosher [MVP-Outlook]" Î*γγÏ�αψε:

What assistance are you looking for? The article goes into quite a few details on how to implement it in Word VBA.


"George" wrote in message ...
Dear friends,

I want to send e-mails with an attached file to my contacts (outlook 2003).

I found the following link
http://word.mvps.org/FAQs/MailMerge/...ttachments.htm
and I need help on how to apply it.

Or, any other suggestions will be highly appreciated.

Thanking you in advance,

GeorgeCY