Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-16-2018, 10:27 AM
mkiss mkiss is offline How do I list a column heading in a merge? Windows 10 How do I list a column heading in a merge? Office 2013
Novice
How do I list a column heading in a merge?
 
Join Date: Nov 2018
Posts: 1
mkiss is on a distinguished road
Default How do I list a column heading in a merge?

I have a large excel spreadsheet that has my students listed in column A. Across the top of each column (left to right) I have the course name. In the intersecting cell, it lists the date the student took a particular course.



I can get a mail merge to list the student name then list the course dates under the student. What I can’t figure out (newbie) is how to have the column heading (course name) appear next to the date when merged to Word.

Any suggestions?
Reply With Quote
  #2  
Old 11-16-2018, 01:52 PM
macropod's Avatar
macropod macropod is offline How do I list a column heading in a merge? Windows 7 64bit How do I list a column heading in a merge? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

The column headings would have to be added to your mailmerge main document; they can't be merged from the data source.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
column headings, mail merge

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Attempting to mail merge one list into a document containing 3 pages - each page needs the same list LisaRH Mail Merge 3 08-09-2018 03:01 PM
How do I list a column heading in a merge? Formatted list of which heading a specific Style in 'under' Dwids Word VBA 4 04-20-2018 01:49 AM
How to search with column heading then doing the lookup action for below code cmreddy.vba Excel Programming 0 01-20-2015 03:44 AM
Mail merge how to link mail merge field value to a column heading dsummers Mail Merge 1 05-08-2014 02:59 PM
How do I list a column heading in a merge? How to line up a merged field to a column heading j_Southern Mail Merge 2 10-08-2012 12:28 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:26 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft