Explain creating mail merge using ms-access

Assignment Help Marketing Management

Reference no: EM1324666

Explain Creating Mail Merge using MS-Access

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

Reference no: EM1324666

Questions Cloud

Codes assists in learning and memory : Explain how having two codes assists in learning and memory. Give three examples.

Case study ethics and product quality : HighTech, Inc., manufactures computer chips and components. HighTech has just introduced a new version of its memory chip, which is far faster than the previous version.

Business ethics in a scenario : Who else is involved, or should be involved, in this decision? Who has a stake in the outcome? What alternatives are available to you? What are the consequences of each alternative? How would each of your alternatives affect the other people you have..

Concept of autobiographical memory : Analyze the concept of autobiographical memory using AUTOBIOGRAPHICAL MEMORY article. Briefly summarize AUTOBIOGRAPHICAL MEMORY article.

Explain creating mail merge using ms-access : Explain Creating Mail Merge using MS-Access and write a query that shows only the customers who live in MyTown

The effects of emotions on memory : Describe the difference in the effects of positive emotions on memory and stressful or fearful emotions on memory.

Sample question based on memory : There are events that are clearly negative that produce memories more vivid than almost any positive memory

Explain the steps in developing a website : Explain the steps in developing a website

Difficult ethical issues hospital marketers : The following case study illustrates some difficult ethical issues hospital marketers face on the job. When deciding on the best way to confront these "gray" ethical areas, hospitals marketers should use these questions as a guide:

User Account

All Pages