9-8 Creating a Word doc from an Excel list

UMaine Alert

Posted: April 19, 2024 - 1:32 PM

At approximately 9:24 a.m. on Friday, April 19, a University of Maine graduate student was struck by a university vehicle on Long Road at the University of Maine campus in Orono. The student reports that they are at a local hospital with minor injuries.

Emergency services, including the Orono Fire Department, University Volunteer Ambulance Corps, University of Maine Police Department, Orono Police Department and Penobscot County Sheriff’s Office responded to the scene.

The university vehicle involved in the incident was a Chevrolet Express van. It was being operated by a university employee.

Counseling services and support are available for students, faculty or staff who may have been affected. The Counseling Center can be reached at 207-581-1392 and the Dean of Students Office can be reached at 207-581-1406.

The scene has been cleared and Long Road is now accessible. An investigation is being conducted by the University of Maine Police Department with assistance from the Penobscot County Sheriff’s Office Crash Reconstruction Unit. Any witnesses to the incident are encouraged to contact Lt. Noel Santiago at noel.santiago@maine.edu.

Purpose: To create a Word document from an existing Excel list (using Mail Merge function of Word)

Open Word
Click on Mailings tab
Click Start Mailing merge
Choose Directory
Click Select Recipients
Choose Use Existing List
From the Select Data Source box, find and choose your Excel file
Click Ok in the Select Table Box
Click Insert Merge Field
From the dropdown list, choose the fields that you wish to appear in each entry
Format the fields as needed (add bolding, bullets, etc.)
Click Preview Results to see how your entries will appear and make adjustments if necessary
Click Finish and Merge
Click Edit Individual Documents
In the Merge to New Document box, choose All and click Ok
Your list will appear (it may take a minute or so depending on the length). Ready to edit and save.