PDA

View Full Version : Access 2010 Personalized Letter HELP



newbieform12
06-09-2012, 07:08 PM
HI Guys, please can someone help me??


I have a database called Customers. There is a table that contains information about the customer including the fields FirstName, LastName, Street address, Suburb, City and Email Address and their credit limit.

the letter is personalize and need to send it by email to each client.

Dear Joe Bloggs,
It is with great pleasure that we would like to inform you that your new credit limit with our company is now $10,000.

We look forward to doing business with you.

Yours sincerely,
.....
......

If I had a customer called Harry Potter

it would read:

Dear Harry Potter
It is with great pleasure that we would like to inform you that your new credit limit with our company is now $10,000.

We look forward to doing business with you.

Yours sincerely,
.....
......

MacroShadow
06-16-2012, 03:40 PM
So what are you trying do do, and what have tried so far?