How to make mail receipent program in microsoft office 2007

A classic!

In Microsoft Office 2007, you can create a mail merge recipient list using the following steps:

Step 1: Create a new database

• Open Microsoft Access 2007 (it's included with Office 2007) and create a new database by clicking on "Blank Database" in the start page.
• Name your database (e.g., "Mail Merge Recipients") and click "Create".

Step 2: Design the database

• In the Access database, create a new table by clicking on "Create" > "Table" in the ribbon.
• Name the table (e.g., "Recipients") and add the following fields:
  • First Name
  • Last Name
  • Email Address
  • Address (optional)
  • City (optional)
  • State (optional)
  • ZIP (optional)
• Save the table.

Step 3: Enter recipient data

• Open the "Recipients" table and enter the data for each recipient. You can add as many records as you need.
• Make sure to enter the data in a format that can be easily imported into Microsoft Word (e.g., use commas or semicolons to separate fields).

Step 4: Export the database

• In the Access database, click on "File" > "Export" > "Export Table" in the ribbon.
• Select "Microsoft Excel" as the export format and choose a location to save the file.
• Name the file (e.g., "Recipients.xlsx") and click "Export".

Step 5: Create a mail merge document in Microsoft Word

• Open Microsoft Word 2007 and create a new document.
• Click on "Mailings" > "Start Mail Merge" > "Step-by-Step Mail Merge Wizard" in the ribbon.
• Follow the wizard to create a new mail merge document.
• In the "Select recipients" step, choose "Use an existing list" and select the Excel file you exported in Step 4.

Step 6: Merge the data

• Click "Next" and then "Finish" to merge the data into your Word document.
• The mail merge will insert the recipient data into your document, using the fields you defined in the database.

That's it! You now have a mail merge recipient list program in Microsoft Office 2007.

Note: If you're not familiar with Access or mail merge, you may want to explore online tutorials or seek assistance from a Microsoft Office expert.