Creating Mail Merge using MS-Access
Not what you're looking for?
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.