DB2 Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsDatabasesDB2 Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now!
  #1  
Old January 19th, 2007, 06:16 AM
malhyp malhyp is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Jun 2006
Posts: 10 malhyp User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 h 57 m 23 sec
Reputation Power: 0
Info Help: Emailing from Access via Outlook

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

Reply With Quote
  #2  
Old January 19th, 2007, 09:07 AM
LKBrwn_DBA LKBrwn_DBA is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Sep 2006
Posts: 294 LKBrwn_DBA User rank is Sergeant (500 - 2000 Reputation Level)LKBrwn_DBA User rank is Sergeant (500 - 2000 Reputation Level)LKBrwn_DBA User rank is Sergeant (500 - 2000 Reputation Level)LKBrwn_DBA User rank is Sergeant (500 - 2000 Reputation Level)LKBrwn_DBA User rank is Sergeant (500 - 2000 Reputation Level) 
Time spent in forums: 2 Days 16 h 48 m 15 sec
Reputation Power: 9
Cool


Google's your best friend, here is the result!

Reply With Quote
Reply

Viewing: Dev Shed ForumsDatabasesDB2 Development > Info Help: Emailing from Access via Outlook


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 5 hosted by Hostway