Scribd Logo
Upload

Welcome to Scribd!

  • 10K views

    Mail Merge Excercie 1

    Uploaded by

    ashisparida08
    The document provides instructions for a mail merge exercise involving creating a table of customer data and a template letter. It instructs the user to [1] create a table with customer names, addresses, card numbers, balances and limits and [2] create a template letter to notify customers who have exceeded their credit limits. [3] The user is then asked to perform a mail merge to combine the template letter with the customer data table.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as DOCX, PDF, TXT or read online from Scribd

    Mail Merge Excercie 1

    Uploaded by

    ashisparida08
    10K views2 pages
    The document provides instructions for a mail merge exercise involving creating a table of customer data and a template letter. It instructs the user to [1] create a table with customer names, addresses, card numbers, balances and limits and [2] create a template letter to notify customers who have exceeded their credit limits. [3] The user is then asked to perform a mail merge to combine the template letter with the customer data table.

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document provides instructions for a mail merge exercise involving creating a table of customer data and a template letter. It instructs the user to [1] create a table with customer names, addresses, card numbers, balances and limits and [2] create a template letter to notify customers who have exceeded their credit limits. [3] The user is then asked to perform a mail merge to combine the template letter with the customer data table.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    10K views2 pages

    Mail Merge Excercie 1

    Uploaded by

    ashisparida08
    The document provides instructions for a mail merge exercise involving creating a table of customer data and a template letter. It instructs the user to [1] create a table with customer names, addresses, card numbers, balances and limits and [2] create a template letter to notify customers who have exceeded their credit limits. [3] The user is then asked to perform a mail merge to combine the template letter with the customer data table.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 2

    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 Dublin Cork Galway

    Card No 334455 3456 3456 9876 5780

    Balance Limit Charge Interest 4678 3500 499 12% 3000 2000 375 17% 1234 3400 1200 1000 550 2255 998 1045 369 1305 450 1650 599 22% 21% 23% 12% 17%

    Kilkenny 3456789 1500 Wicklow 9672343 1999

    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 account is currently being charged the following interest rate XXX. Regards, Your name Account manager

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

    You might also like