Do My Homework | mail merge

>Business & Finance homework help

Order Completion Rating

Available Experts

Similar homework solved

This homework (among 17 others) was first solved on May 17th, 2022 by our USA essay writers.

mail merge

For this assignment, you will create a Word document that is mail merged with an Excel customer contact table. Mail Merge can be used to create bulk labels, letters, envelopes, and emails. You will be creating letters to send with the newsletter you previously edited (Links to an external site.). Follow the directions below, then submit your assignment. If you get stuck on a step, review this module and ask your classmates for help in the discussion forum.
You have been tasked with mailing the newsletter you previously created to customers of Rowan Retail. In order to accomplish this task, you need to merge the customer contact information in the Excel file with a Word document in order to make mailing labels. Follow these steps to accomplish the task.

The first step is to download the customer contact Excel file (Links to an external site.) and save it to the Rowan folder on your desktop.
Open Word and create a new document by clicking on the Blank document option in the window.
Save the document by using Save As and rename the document to BA132_LastName_MailMerge.docx, replacing “LastName” with your own last name. (Example: BA132_Hywater_MailMerge)
Select the Mailings tab then the Start Mail Merge button and select Step-by-Step Mail Merge Wizard.

In the Mail Merge menu, click the Next: Starting document link.

You will be creating letters for the contacts who will receive the newsletter, so leave the document type in Letters and click the Next: Select recipients link.

You already have a file with a contact list. Leave the selection Use an existing list selected and click on the Browse link. This will open up a dialog box for your computer.

Select the correct folder and scroll through the files until you find the Rowan Retail Customer Contacts.xlsx file. Either double-click on the file or select it and click the Open button.

A different dialog window will open that allows you to choose the different tabs in the Excel file. The Customer Contact Data$ is the one you want. Either double-click on the file or select it and click the Open button. Note: Leave the box checked since your data file’s first row is a header row.

After you have clicked the OK button, a final dialog box appears. It shows all of the contacts in the file. Find Richard Castle and Britney Spears and uncheck their boxes. They do not need a newsletter. Now click the OK button and then the Next: Write your letter link.

Now begin to compose the letter by first placing your cursor in the document page where you want the address. Click the Address Block option from the wizard or the ribbon button, select the naming style, then click OK.

Next, place the cursor where you would like the greeting to be in the letter. Select the Greeting line from the wizard or the ribbon button, decide the style of greeting, and click the OK button.

Paste the following text to serve as the body of your letter.

Enclosed is the quarterly newsletter for Rowan Retail. Please enjoy the information therein and pay special attention to the dates for the special sales this summer. If you have any questions or concerns, please contact us as soon as possible.

Close the letter with “Sincerely” and then your name. Save your work, then click Next: Preview your letters.

Scroll through the letters by clicking on the arrows. You should be missing Britney Spears and Richard Castle in the recipients. Now click on Next: Complete the merge.

Your merge mail file is now complete! Save your file once more, this time as a PDF (use the .pdf file extension), and submit the PDF to Canvas.


Over 750+ Essays and assignments completed every week by professional essay writers and research experts helping students all over the world complete their homework on time and at the same get A’s in their graded assignments.


Why Use Paper Research Homework Help and Custom Writing For Scholars; by Experts?

We provide students with Reliable custom writing service by USA tutors and researchers. Access fast, affordable and plagiarism free papers from professional essay writers.

~ Features include: Free Consultation, Turnitin Plagiarism Report, Free first-page & References page, Professional Tutors & Research Experts.

Hire a professional essay writer to create a solution from scratch

Order Now, and get an original solution to this assignment with zero plagiarism. Use GATEWAY10 to get a 10% discount on all orders.

Why students choose our experts for homework help, assignments, and coursework

Here are some Benefits of ordering a solution to this homework from us:


Full and Instant Money back guarantee

Free proof-reading and editing

Timely delivery

Cheapest homework help writing service


Best custom writing service in US, UK, Australia, and China

100% Reliability and Trust. Satisfaction and Value for money guaranteed.

Solutions with Zero-Plagiarism

Our professional writers will create an original solution for your homework written from scratch. A plagiarism report of your homework is also available.

Free Unlimited Revisions

Our experts will revise your paper until you are satisfied with the final delivery.

24|7 Priority Support

You can communicate with us at any given moment.

Professional Writers and Research Experts

Our team consists of determined, disciplined and ambitious experts with competitive degrees from top Universities from across the world.

Thorough research to complete your assignment

A good research into your paper improves its credibility, gives it higher ranking, and makes your argument solid. That is why our team consists of research experts to guide and work with the writers in preparing your papers.

Frequently Asked Questions

Is this service Legit?

This is an extension of Gateway Assignment essay writing services. Gateway is a group of writers brought together by the desire to help students achieve more in essay writing. Our Writers are experts in tutoring, research, and writing activities. We have worked with over 5,000 students pursuing college, undergraduate, Masters, and Ph.D. degrees. Our Services are Trusted and Verified.

Will My Paper have plagiarism?

No. Absolutely Not. All our Papers are Original and are written by our experts from scratch. To be sure, you can request a plagiarism report when placing an order.

How Fast can you deliver my paper?

Any duration you select when choosing a deadline for the paper. The number of hours could be 3 hours to 24 hours to 2 days, a month, or any other duration.

For short assignments ranging between 1 page and 3 pages(100 – 1000 words), we can have them delivered in 1 hour.

Can I get a professional writer to write my essay?

Absolutely Yes. If you are looking for the most reliable and executive essay writing service, you are in the right place.

Our Service is a program dedicated to improving student’s achievement in essay writing assignments. In our company, professional tutors and expert writers work together to create original solutions to help students complete their assignments.

Our essay writing service is the most reliable writing help online. Our writers are former students and researchers in leading institutions across the world.

Our founder, Frank, is a legend writer and educator who has contributed significantly to improving the performance of thousands of students.

The goal of Gateway Assignment is to lead in changing the learning process by allowing students to access unlimited resources in writing their essays.

How Much will it Cost?

Our Rates start at $10 per page (275 words). Plus:

  • Free First Page
  • Free Reference Page
  • Free Unlimited Revisions

Can I get a Discount for my first paper?

Ofcos. Use the discount code “GATEWAY20” at checkout to get a 20% discount off on all essays you order.

Do I get a refund if I am not satisfied with the paper?

Yes. Anytime you establish that Our Services did not help you meet your desired outcome, you are entitled to a Full Refund. Read our refund policy to learn more.

'One More Question'?

Chat with a live agent on the floating chat. Frank is online now.

Questions Recently Solved by Our Experts

Do My Homework | Wk 2 Annotated Bibliography (Kim Woods Only) Due in 1 day

This homework was first solved May 17, 2022. Read all pages carefully, selected topic, intro & must be follow format according to Sample Paper (3-3 Para each Article)          

Must be 100% Original          

I hv already attached Articles, u must be use this 3 articles for Annotated Bibliography 

Instructor Comment on last work: Reference must be write according to APA 7TH Format

read more

Do My Homework | How to Use QuickBooks connection diagnostic tool?

This homework was first solved May 17, 2022.  This tool is also capable of troubleshooting network, multi-user and many other errors while using or attempting to use a QuickBooks company file. QB desktop uses core Microsoft components and if any component is missing or not functioning, the situation may trigger errors. The connection diagnostic tool is compatible only with Microsoft Windows 7, Windows Vista, or Windows XP with QuickBooks 2008 and later versions. 

 How to Use QuickBooks connection diagnostic tool? 
Open the QuickBooks Connection Diagnostic Tool on your screen and follow the instructions given below.
Step 1: Diagnose Connection Tab
It lets you check the system set up and to be sure that the company file can be used from any system whether you work on single-user mode or multi-user mode. If you don’t have the proper permission or the ports or system firewall is blocked, you may receive errors.
Step 2: Firewall Status
This tab informs you about the basic instructions of the system firewall.
Step 3: Test Connectivity 

read more

Do My Homework | assignment

This homework was first solved May 17, 2022. The article summary is a 250 words in length double-spaced (1 pages), summary of the 2 main viewpoints addressed in chapter 6 of the Wolff text, An Introduction to Moral Philosophy: psychological egoism and ethical egoism.  For each viewpoint, carry out the following steps:
1)First define and explain both viewpoints: one or two sentences for each.
2)Second, concisely state the reasoning from the text for each of these viewpoints.
3)Finally, give your own evaluation of them.  Do you agree or disagree with one, or both?  Why or why not?

read more

Get a Plagiarism-free paper Today

Order an essay, term paper, research paper, or any other assignment and get an expert to work on it. Use GATEWAY20 to get a 20% discount on all papers.

Alternatively, Check Out the FIVE STEPS in writing an essay