Mail Merge Excercie 1 3kl35

Mail Merge Exercise 1: Step 1: Create the following Table and save it.

Name J. Bloggs M. Brown P. White S. Jones N. Robins S. Hoynes D. Kilpatrick

Add1 Flat 3 20 Packgate 15 Westlawn 81 leafy 55 Beech Tree 43 The Hill New House

City Dublin Dublin

Card No 334455 3456

Balance Limit Charge Interest €4678 €3500 499 12% €3000 €2000 375 17%

Dublin

3456

€1234

€1000 550

22%

Cork Galway

9876 5780

€3400 €1200

€2255 998 €1045 369

21% 23%

Kilkenny 3456789 €1500

€1305 450

12%

9672343 €1999

€1650 599

17%

Wicklow

Step 2: Open a new word document and create the following letter. Save it.

Re: Card NO. XXX Dear XXX We are disappointed to note that you have exceeded your credit card limit of XXX and your balance currently is XXX. Please note that you must now pay a charge of XXX to reactivate your card. You are advised to do so within the next week. In future please note that your balance is XXX and do not exceed your limit of XXX. Your is currently being charged the following interest rate XXX. Regards, Your name manager

Step 3: Follow the Mail Merge Steps to merge this letter with the data in the table above.