Emailing

  • Thread starter Thread starter Matt
  • Start date Start date
M

Matt

We are in the process of designing a database which we be
used for:
1. Sending out emails to all people listed on the database
2. Collection of important business contact information
for our business.

One of the tables will be storing the address, email,
website of the organisation.

What I would like to achieve is a command button that
automatically places all the email addresses on our
database into the bcc: field in a new email message.

We will then attach our E-zing, which is not stored in the
database.

Any help would be very appreciated.

Matt.
 
Ed,
Thanks for the response. Yes I have find SendObject before
and I am able to write a Macro to send individual email
address or to email addresses that I write in the addtess:

EG.

Action: I choose SendObject
Object type: I choose is a query with just the email
addresses. [qryEmails]
Output Format: I am not sure as I want the query to be put
in the BCC: field in my email message
To:
Cc:
Bcc: I tried putting the field name [emails] in here,
hoping that it would pick up all of them, but when I run
the macro it just puts [emails]

Is there something that I am missing to enable me to
achieve my goal.

Regards


Matt.
 
What I have done in the past is to set up a 'loop' with all the email
addresses and send an individual email to each person.

ed

Matt said:
Ed,
Thanks for the response. Yes I have find SendObject before
and I am able to write a Macro to send individual email
address or to email addresses that I write in the addtess:

EG.

Action: I choose SendObject
Object type: I choose is a query with just the email
addresses. [qryEmails]
Output Format: I am not sure as I want the query to be put
in the BCC: field in my email message
To:
Cc:
Bcc: I tried putting the field name [emails] in here,
hoping that it would pick up all of them, but when I run
the macro it just puts [emails]

Is there something that I am missing to enable me to
achieve my goal.

Regards


Matt.
-----Original Message-----
The VBA command you want is SendObject Method. Look in Help for an example.

ed




.
Click to expand...
Click to expand...
 
Back
Top