Explore BrainMass

Explore BrainMass

    Creating Mail Merge using MS-Access

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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

    © BrainMass Inc. brainmass.com March 4, 2021, 11:04 pm ad1c9bdddf

    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 ...

    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.