![]() |
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 |
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 |
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 |
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 06:11 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