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.

[TABLE="width: 1474"]
<colgroup><col span="2"><col><col><col span="3"><col><col span="10"></colgroup><tbody>[TR]
[TD]Program Director First Name[/TD]
[TD]Program Direct Last Name[/TD]
[TD]PD[/TD]
[TD]E-mail Address[/TD]
[TD]Section Department[/TD]
[TD]Campus Code[/TD]
[TD]Faculty Full Name (Last, First)[/TD]
[TD]Section Department Description[/TD]
[TD]Meeting Campus Code[/TD]
[TD]Section Course Number[/TD]
[TD]Section Session Year (Combined)[/TD]
[TD]Section Number[/TD]
[TD]Section Title (Full)[/TD]
[TD]Section Credit Hours[/TD]
[TD]Section Begin Date[/TD]
[TD]Section End Date[/TD]
[TD]Number Registered[/TD]
[TD]Course Comments[/TD]
[/TR]
[TR]
[TD]Robert[/TD]
[TD]Harris[/TD]
[TD]Robert Harris[/TD]
[TD]debra.lucius@alliant.edu[/TD]
[TD]Clinical PsyD[/TD]
[TD]FRES[/TD]
[TD]Staff[/TD]
[TD]Clinical PsyD[/TD]
[TD]FRES[/TD]
[TD]PSY7911[/TD]
[TD]FA2017[/TD]
[TD]F1[/TD]
[TD]Psy.D. PROPOSAL DEVELOPMENT[/TD]
[TD="align: right"]3[/TD]
[TD]8/28/2017[/TD]
[TD]12/17/2017[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Robert[/TD]
[TD]Harris[/TD]
[TD]Robert Harris[/TD]
[TD]debra.lucius@alliant.edu[/TD]
[TD]Clinical PsyD[/TD]
[TD]FRES[/TD]
[TD]Staff[/TD]
[TD]Clinical PsyD[/TD]
[TD]FRES[/TD]
[TD]PSY8500[/TD]
[TD]FA2017[/TD]
[TD]F5[/TD]
[TD]CLINICAL ELECTIVE: PSYCHOLOGY OF WOMEN[/TD]
[TD="align: right"]2[/TD]
[TD]8/28/2017[/TD]
[TD]12/17/2017[/TD]
[TD="align: right"]0[/TD]
[TD]Instructor: Kaitlyn Nichols[/TD]
[/TR]
[TR]
[TD]James[/TD]
[TD]Garbanati[/TD]
[TD]James Garbanati[/TD]
[TD]debra.lucius@alliant.edu[/TD]
[TD]Clinical PhD[/TD]
[TD]LA[/TD]
[TD]Staff[/TD]
[TD]Clinical PhD[/TD]
[TD]LA[/TD]
[TD]PSY6101[/TD]
[TD]SU2017[/TD]
[TD]L3[/TD]
[TD]COGNITIVE & AFFECTIVE BASES OF BEHAVIOR[/TD]
[TD="align: right"]2[/TD]
[TD]6/5/2017[/TD]
[TD]7/21/2017[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Hye-Sun[/TD]
[TD]Ro[/TD]
[TD]Hye-Sun Ro[/TD]
[TD]debra.lucius@alliant.edu[/TD]
[TD]Couple & Family Therapy[/TD]
[TD]LA[/TD]
[TD]Staff[/TD]
[TD]Couple & Family Therapy[/TD]
[TD]LA[/TD]
[TD]PSY6110[/TD]
[TD]FA2017[/TD]
[TD]L1[/TD]
[TD]PERSONALITY AND AFFECT[/TD]
[TD="align: right"]3[/TD]
[TD]8/28/2017[/TD]
[TD]12/17/2017[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Hye-Sun[/TD]
[TD]Ro[/TD]
[TD]Hye-Sun Ro[/TD]
[TD]debra.lucius@alliant.edu[/TD]
[TD]Couple & Family Therapy[/TD]
[TD]LA[/TD]
[TD]Staff[/TD]
[TD]Couple & Family Therapy[/TD]
[TD]LA[/TD]
[TD]PSY6313[/TD]
[TD]FA2017[/TD]
[TD]L1[/TD]
[TD]MFT TECHNIQUES LAB I[/TD]
[TD="align: right"]1[/TD]
[TD]8/28/2017[/TD]
[TD]12/17/2017[/TD]
[TD="align: right"]0[/TD]
[TD]Instructor: Sara Lee[/TD]
[/TR]
[TR]
[TD]Hye-Sun[/TD]
[TD]Ro[/TD]
[TD]Hye-Sun Ro[/TD]
[TD]debra.lucius@alliant.edu[/TD]
[TD]Couple & Family Therapy[/TD]
[TD]LA[/TD]
[TD]Staff[/TD]
[TD]Couple & Family Therapy[/TD]
[TD]LA[/TD]
[TD]PSY6313[/TD]
[TD]FA2017[/TD]
[TD]L2[/TD]
[TD]MFT TECHNIQUES LAB I[/TD]
[TD="align: right"]1[/TD]
[TD]8/28/2017[/TD]
[TD]12/17/2017[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Hye-Sun[/TD]
[TD]Ro[/TD]
[TD]Hye-Sun Ro[/TD]
[TD]debra.lucius@alliant.edu[/TD]
[TD]Couple & Family Therapy[/TD]
[TD]LA[/TD]
[TD]Staff[/TD]
[TD]Couple & Family Therapy[/TD]
[TD]LA[/TD]
[TD]PSY6313[/TD]
[TD]FA2017[/TD]
[TD]L3[/TD]
[TD]MFT TECHNIQUES LAB I[/TD]
[TD="align: right"]1[/TD]
[TD]8/28/2017[/TD]
[TD]12/17/2017[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Hye-Sun[/TD]
[TD]Ro[/TD]
[TD]Hye-Sun Ro[/TD]
[TD]debra.lucius@alliant.edu[/TD]
[TD]Couple & Family Therapy[/TD]
[TD]LA[/TD]
[TD]Staff[/TD]
[TD]Couple & Family Therapy[/TD]
[TD]LA[/TD]
[TD]PSY6328[/TD]
[TD]FA2017[/TD]
[TD]L1[/TD]
[TD]INDIVIDUAL AND FAMILY LIFE CYCLE[/TD]
[TD="align: right"]3[/TD]
[TD]8/28/2017[/TD]
[TD]12/17/2017[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Steve[/TD]
[TD]Fisher[/TD]
[TD]Steve Fisher[/TD]
[TD]debra.lucius@alliant.edu[/TD]
[TD]School Psychology[/TD]
[TD]SAND[/TD]
[TD]Staff[/TD]
[TD]School Psychology[/TD]
[TD]SAND[/TD]
[TD]EDP8023[/TD]
[TD]SU2017[/TD]
[TD]50[/TD]
[TD]BEHAVIOR INTERVENTIONS AND CRISIS MANAGEMENT IN THE CLASSROOM[/TD]
[TD="align: right"]2[/TD]
[TD]6/5/2017[/TD]
[TD]7/20/2017[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Shirley[/TD]
[TD]Baker[/TD]
[TD]Shirley Baker[/TD]
[TD]debra.lucius@alliant.edu[/TD]
[TD]Educational Leadership[/TD]
[TD]SAND[/TD]
[TD]Staff[/TD]
[TD]Educational Leadership[/TD]
[TD]SAND[/TD]
[TD]ELM8832[/TD]
[TD]SU2017[/TD]
[TD]S1[/TD]
[TD]LAW, ETHICS AND EQUITY[/TD]
[TD="align: right"]3[/TD]
[TD]6/5/2017[/TD]
[TD]7/9/2017[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Shirley[/TD]
[TD]Baker[/TD]
[TD]Shirley Baker[/TD]
[TD]debra.lucius@alliant.edu[/TD]
[TD]Educational Leadership[/TD]
[TD]SAND[/TD]
[TD]Staff[/TD]
[TD]Educational Leadership[/TD]
[TD]SAND[/TD]
[TD]ELM8878[/TD]
[TD]SU2017[/TD]
[TD]S1[/TD]
[TD]STUDENT AND PERSONNEL SERVICES IN HIGHER EDUCATION[/TD]
[TD="align: right"]3[/TD]
[TD]7/10/2017[/TD]
[TD]8/13/2017[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Shirley[/TD]
[TD]Baker[/TD]
[TD]Shirley Baker[/TD]
[TD]debra.lucius@alliant.edu[/TD]
[TD]Educational Leadership[/TD]
[TD]SAND[/TD]
[TD]Staff[/TD]
[TD]Educational Leadership[/TD]
[TD]SAND[/TD]
[TD]ELM8999[/TD]
[TD]SU2017[/TD]
[TD]S1[/TD]
[TD]SPECIAL TOPICS:[/TD]
[TD="align: right"]3[/TD]
[TD]6/5/2017[/TD]
[TD]7/9/2017[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Shirley[/TD]
[TD]Baker[/TD]
[TD]Shirley Baker[/TD]
[TD]debra.lucius@alliant.edu[/TD]
[TD]Educational Leadership[/TD]
[TD]SAND[/TD]
[TD]Staff[/TD]
[TD]Educational Leadership[/TD]
[TD]SAND[/TD]
[TD]GSE9901[/TD]
[TD]FA2017[/TD]
[TD]S1[/TD]
[TD]DISSERTATION PLAN[/TD]
[TD="align: right"]3[/TD]
[TD]8/28/2017[/TD]
[TD]12/17/2017[/TD]
[TD="align: right"]0[/TD]
[TD]Instructor: Robert Voelkel[/TD]
[/TR]
[TR]
[TD]Shirley[/TD]
[TD]Baker[/TD]
[TD]Shirley Baker[/TD]
[TD]debra.lucius@alliant.edu[/TD]
[TD]Educational Leadership[/TD]
[TD]SAND[/TD]
[TD]Staff[/TD]
[TD]Educational Leadership[/TD]
[TD]SAND[/TD]
[TD]GSE9902[/TD]
[TD]FA2017[/TD]
[TD]S2[/TD]
[TD]DISSERTATION PROPOSAL[/TD]
[TD="align: right"]3[/TD]
[TD]8/28/2017[/TD]
[TD]12/17/2017[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Marianne[/TD]
[TD]Miller[/TD]
[TD]Marianne Miller[/TD]
[TD]debra.lucius@alliant.edu[/TD]
[TD]Couple & Family Therapy[/TD]
[TD]SAND[/TD]
[TD]Staff[/TD]
[TD]Couple & Family Therapy[/TD]
[TD]SAND[/TD]
[TD]PSY6303[/TD]
[TD]SU2017[/TD]
[TD]S1[/TD]
[TD]GROUP THERAPY[/TD]
[TD="align: right"]3[/TD]
[TD]6/5/2017[/TD]
[TD]8/13/2017[/TD]
[TD="align: right"]0[/TD]
[TD]Intructor: Prof. Zappier[/TD]
[/TR]
[TR]
[TD]Marianne[/TD]
[TD]Miller[/TD]
[TD]Marianne Miller[/TD]
[TD]debra.lucius@alliant.edu[/TD]
[TD]Couple & Family Therapy[/TD]
[TD]SAND[/TD]
[TD]Staff[/TD]
[TD]Couple & Family Therapy[/TD]
[TD]SAND[/TD]
[TD]PSY6303[/TD]
[TD]SU2017[/TD]
[TD]S3[/TD]
[TD]GROUP THERAPY[/TD]
[TD="align: right"]3[/TD]
[TD]6/5/2017[/TD]
[TD]8/13/2017[/TD]
[TD="align: right"]0[/TD]
[TD]Instructor: Prof. Zappier[/TD]
[/TR]
[TR]
[TD]Shirley[/TD]
[TD]Baker[/TD]
[TD]Shirley Baker[/TD]
[TD]debra.lucius@alliant.edu[/TD]
[TD]Educational Leadership[/TD]
[TD]SAND[/TD]
[TD]Staff[/TD]
[TD]Educational Leadership[/TD]
[TD]SAND[/TD]
[TD]TEL8175[/TD]
[TD]FA2017[/TD]
[TD]S1[/TD]
[TD]INTEGRATIVE TECHNOLOGY SYSTEMS IN HIGHER EDUCATION[/TD]
[TD="align: right"]3[/TD]
[TD]10/23/2017[/TD]
[TD]12/17/2017[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
 

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