Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.



Windows 7: Microsoft Access 2010 Personalized Letter?

09 Jun 2012   #1

windows 7 32bit
 
 
Microsoft Access 2010 Personalized Letter?

Hi Guys

I have a question..

I have a database called customers with their information (First Name, Last Name, street address etc)

I have written a personalized letter and would like to send it to each customer in the database

Dear Joe Bloggs
It is with great pleasure that we would like to inform you ........

Your Sincerly
...............

What I want to do is, Replace "Joe Bloggs" with the name of each of the customers

If I had Sue Rain as a customer the letter would be

Dead Sue Rain
It is with great pleasure that we would like to inform you ........

Your Sincerly
...............

I will need to Email the personalized letter to each customer

Hope someone can help

Mark

My System SpecsSystem Spec
.

12 Jun 2012   #2

Win7-64
 
 

You can do this by having Access drive either Outlook or the system's default email program, but you have to do this with VBA code. If you know how to write VBA I can send you some sample code that works. There is a condition though - if the email requires attachments the code is more complex and must use Outlook. If it is just a simple text-only email then the code can be simpler and can use the system's default email program. In my case I had to accommodate attachments (up to 5 of them!) so I had to do the more complex code for Outlook.
My System SpecsSystem Spec
Reply

 Microsoft Access 2010 Personalized Letter?





Thread Tools



Similar help and support threads for2: Microsoft Access 2010 Personalized Letter?
Thread Forum
Access 2000 VS Access 2010 Database replication Microsoft Office
Any problems using Access 2007 database with Access 2010? Microsoft Office
Microsoft Access 2010 not responding message Microsoft Office
MicroSoft Access 2010 keeps crashing w/ W7 Microsoft Office
Office 2010 Generally Available in June 2010, Microsoft News

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 12:32 PM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33