New
#1
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