Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook - Using Forms (http://www.outlookbanter.com/outlook-using-forms/)
-   -   Info Help: Emailing from Access via Outlook (http://www.outlookbanter.com/outlook-using-forms/38280-info-help-emailing-access-via.html)

Malhyp January 19th 07 09:38 PM

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

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


Sue Mosher [MVP-Outlook] January 19th 07 09:43 PM

Info Help: Emailing from Access via Outlook
 
Word mail merge is the solution.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Malhyp" wrote in message ...

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

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


afn48505 March 1st 07 04:23 PM

Info Help: Emailing from Access via Outlook
 
I have a similar problem as the original, except I am not working with a
database. I get emails that have exactly the same pattern to them. I would
like to strip the data and save them as fields. Is there an easy way to do
that?

afn


"Sue Mosher [MVP-Outlook]" wrote:

Word mail merge is the solution.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Malhyp" wrote in message ...

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

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



Sue Mosher [MVP-Outlook] March 1st 07 05:03 PM

Info Help: Emailing from Access via Outlook
 
Mally was trying to send messages. You're trying to process received messages. Therefore, your issue is totally different. In the future, please start a new discussion thread with a subject specific to your issue, instead of piggybacking on an unrelated discussion.

See if these pages help with your data extraction issue:

http://www.outlookcode.com/codedetail.aspx?id=89
http://www.slipstick.com/addins/extract.htm


--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"afn48505" wrote in message ...
I have a similar problem as the original, except I am not working with a
database. I get emails that have exactly the same pattern to them. I would
like to strip the data and save them as fields. Is there an easy way to do
that?




All times are GMT +1. The time now is 08:55 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com