One to many mail merge with Excel

dlucius

New Member
Joined
Jul 13, 2012
Messages
9
Hello,
I'm attempting to use the data below with Office 365 Word mail merge. My goal is to send one email to each PD listing all courses where their name appears. The company I work for does not allow users the ability download add-ins. Thank you for your assistance.

Program Director First NameProgram Direct Last NamePDE-mail AddressSection DepartmentCampus CodeFaculty Full Name (Last, First)Section Department DescriptionMeeting Campus CodeSection Course NumberSection Session Year (Combined)Section NumberSection Title (Full)Section Credit HoursSection Begin DateSection End DateNumber RegisteredCourse Comments
RobertHarrisRobert Harrisdebra.lucius@alliant.eduClinical PsyDFRESStaffClinical PsyDFRESPSY7911FA2017F1Psy.D. PROPOSAL DEVELOPMENT38/28/201712/17/20170
RobertHarrisRobert Harrisdebra.lucius@alliant.eduClinical PsyDFRESStaffClinical PsyDFRESPSY8500FA2017F5CLINICAL ELECTIVE: PSYCHOLOGY OF WOMEN28/28/201712/17/20170Instructor: Kaitlyn Nichols
JamesGarbanatiJames Garbanatidebra.lucius@alliant.eduClinical PhDLAStaffClinical PhDLAPSY6101SU2017L3COGNITIVE & AFFECTIVE BASES OF BEHAVIOR26/5/20177/21/20170
Hye-SunRoHye-Sun Rodebra.lucius@alliant.eduCouple & Family TherapyLAStaffCouple & Family TherapyLAPSY6110FA2017L1PERSONALITY AND AFFECT38/28/201712/17/20170
Hye-SunRoHye-Sun Rodebra.lucius@alliant.eduCouple & Family TherapyLAStaffCouple & Family TherapyLAPSY6313FA2017L1MFT TECHNIQUES LAB I18/28/201712/17/20170Instructor: Sara Lee
Hye-SunRoHye-Sun Rodebra.lucius@alliant.eduCouple & Family TherapyLAStaffCouple & Family TherapyLAPSY6313FA2017L2MFT TECHNIQUES LAB I18/28/201712/17/20170
Hye-SunRoHye-Sun Rodebra.lucius@alliant.eduCouple & Family TherapyLAStaffCouple & Family TherapyLAPSY6313FA2017L3MFT TECHNIQUES LAB I18/28/201712/17/20170
Hye-SunRoHye-Sun Rodebra.lucius@alliant.eduCouple & Family TherapyLAStaffCouple & Family TherapyLAPSY6328FA2017L1INDIVIDUAL AND FAMILY LIFE CYCLE38/28/201712/17/20170
SteveFisherSteve Fisherdebra.lucius@alliant.eduSchool PsychologySANDStaffSchool PsychologySANDEDP8023SU201750BEHAVIOR INTERVENTIONS AND CRISIS MANAGEMENT IN THE CLASSROOM26/5/20177/20/20170
ShirleyBakerShirley Bakerdebra.lucius@alliant.eduEducational LeadershipSANDStaffEducational LeadershipSANDELM8832SU2017S1LAW, ETHICS AND EQUITY36/5/20177/9/20170
ShirleyBakerShirley Bakerdebra.lucius@alliant.eduEducational LeadershipSANDStaffEducational LeadershipSANDELM8878SU2017S1STUDENT AND PERSONNEL SERVICES IN HIGHER EDUCATION37/10/20178/13/20170
ShirleyBakerShirley Bakerdebra.lucius@alliant.eduEducational LeadershipSANDStaffEducational LeadershipSANDELM8999SU2017S1SPECIAL TOPICS:36/5/20177/9/20170
ShirleyBakerShirley Bakerdebra.lucius@alliant.eduEducational LeadershipSANDStaffEducational LeadershipSANDGSE9901FA2017S1DISSERTATION PLAN38/28/201712/17/20170Instructor: Robert Voelkel
ShirleyBakerShirley Bakerdebra.lucius@alliant.eduEducational LeadershipSANDStaffEducational LeadershipSANDGSE9902FA2017S2DISSERTATION PROPOSAL38/28/201712/17/20170
MarianneMillerMarianne Millerdebra.lucius@alliant.eduCouple & Family TherapySANDStaffCouple & Family TherapySANDPSY6303SU2017S1GROUP THERAPY36/5/20178/13/20170Intructor: Prof. Zappier
MarianneMillerMarianne Millerdebra.lucius@alliant.eduCouple & Family TherapySANDStaffCouple & Family TherapySANDPSY6303SU2017S3GROUP THERAPY36/5/20178/13/20170Instructor: Prof. Zappier
ShirleyBakerShirley Bakerdebra.lucius@alliant.eduEducational LeadershipSANDStaffEducational LeadershipSANDTEL8175FA2017S1INTEGRATIVE TECHNOLOGY SYSTEMS IN HIGHER EDUCATION310/23/201712/17/20170

<colgroup><col span="2"><col><col><col span="3"><col><col span="10"></colgroup><tbody>
</tbody>
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

Forum statistics

Threads
1,215,221
Messages
6,123,699
Members
449,117
Latest member
Aaagu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top