Purchase Solution

Creating Mail Merge using MS-Access

Not what you're looking for?

Ask Custom Question

Create a Mail Merge using Microsoft Access as the record source. The Mail Merge document should be professionally formatted and needs to include the following:

1. A logo for Front Row Video
2. A watermark formatted behind the text
3. Margins set at 1.5"
4. Add your name to the database, but enter your city as MyTown
5. Write a query that shows only the customers who live in MyTown
6. In that same query, concatenate the First Name and Last Name. Please call it FullName.
7. In that same query, concatenate the City, State and Zip code. Name that new field CityStateZip.
8. Save this query and name it MyTownSQ
9. Create a Mail Merge in Word that includes FullName, Addr1, Addr2, CityStateZip
10. The Date and Time on this Mail Merge should update automatically

Purchase this Solution

Solution Summary

This solution presents a detailed explanation on how to create labels using mail merge feature of MS-Word with an MS Access database as the source of data.

Solution Preview

There are three documents attached:

a) Customer.mdb (The Access database that acts as a source for the Mail Merge. This access database contains a table with 3 records, two of which meet the criteria. This also includes a query which meets the requirements of the question.)

b) CustomerMailMerge.doc: This is the word document that ...

Purchase this Solution


Free BrainMass Quizzes
Operations Management

This quiz tests a student's knowledge about Operations Management

Income Streams

In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.

Motivation

This tests some key elements of major motivation theories.

IPOs

This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)

Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.