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
accessnewbie

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
bbinnard

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
Thread Forum
cannot access my microsoft stater package 2010..
When I attempt to open it the message reads MICROSOFT WORD STARTER 2010 CANNOT BE OPENED. TRY AGAIN OR REPAIR THE PRODUCT IN CONTROL PANEL. I attempted to repair and can't locate the repair link. Please Help
Microsoft Office
Microsoft Access 2010 not responding message
While working on Access 2010 in design mode, I get a message "Access not responding" with the following error message Problem signature: Problem Event Name: BEX Application Name: MSACCESS.EXE Application Version: 14.0.4750.1000 Application Timestamp: 4b8bade7 Fault Module Name: MSVCR90.dll...
Microsoft Office
MicroSoft Access 2010 keeps crashing w/ W7
I have a simple document tracking database that I wrote in the late '80's and have migrated up through the newer versions of MS Access. Recently when I am editing a date entry form it will crash while I'm working. The error message is always similar in that only the "Exception Offset" changes. I...
Microsoft Office
Office 2010 Generally Available in June 2010, Microsoft
The next iteration of the Office System is now approximately five months away Microsoft confirmed to Softpedia. At the start of this week, you were able to read a report on a remark from Microsoft Chief Executive Officer Steve Ballmer, in which the CEO indicated that Office 2010 would be out in...
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 03:48.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App