Info Help: Emailing from Access via Outlook

[malhyp]

Hi to all!

I dont know if this is possible but can someone please suggest if this is
possible and if so where I could find some info on how to do it or what I
should be looking for in this group.

Can I set something up so that I can email from Outlook to all the customers
in the query below?

I have an access database which I have creatged a query that pulls results
from a table with 100 customers in it.

Lately I have been cutting and pasting information from the database and
email every customer individualy.

An example would be as follows.
------------------------------------------------------------------------------

Dear JOHN,
Your listing with us contins the following results...
CAT
DOG
MOUSE
Your listing has been viewed 10 times.
------------------------------------------------------------------------------
The text in capitals are results from three colums in the database.
Colums are called
Name: JOHN
Email:JO**@THEPETSHOP.COM
Result: CAT, DOG & MOUSE
Search Result: 10

Can I set something up so that I can email from Outlook to all the customers
in the query above?

Where can i look to learn how.

Cheers
Mally

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200701/1

[Jana]

Mally:

This is going to take some coding. Take a look at the SendObject
Method in help. That should get you going.

HTH,
Jana

malhyp wrote:

Hi to all!

I dont know if this is possible but can someone please suggest if this is
possible and if so where I could find some info on how to do it or what I
should be looking for in this group.

Can I set something up so that I can email from Outlook to all the customers
in the query below?

I have an access database which I have creatged a query that pulls results
from a table with 100 customers in it.

Lately I have been cutting and pasting information from the database and
email every customer individualy.

An example would be as follows.
------------------------------------------------------------------------------

Dear JOHN,
Your listing with us contins the following results...
CAT
DOG
MOUSE
Your listing has been viewed 10 times.
------------------------------------------------------------------------------
The text in capitals are results from three colums in the database.
Colums are called
Name: JOHN
Email:JO**@THEPETSHOP.COM
Result: CAT, DOG & MOUSE
Search Result: 10

Can I set something up so that I can email from Outlook to all the customers
in the query above?

Where can i look to learn how.

Cheers
Mally

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200701/1