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:JOHN@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

Have you ever used Visual Basic before? It sounds like you're comfortable working with queries ... it's a little more complex, but not so much more.

Access might be able to do this out of the box using Macros ( before Reports, after Forms ). I have a beta of Office 2007, so I can't check and give you a definitive answer for the version you're running... But the first thing I'd look into is whether you can create an email from a macro.

Otherwise, all of the Office apps expose themselves to VBA, so you could write a bit of Visual Basic code to create an instance of Outlook, then create a new email, set the body text from your query's results, and then send it.