I have an Excel document which looks like this (please click on the image to see the full image):



I have many records.
I want to merge these records onto a word document so that it looks like this (please click on the image to see the full image:



How can I do this? I need to put similar information for several people on the word document (thus, about 6 records per page)

Can I also merge the font?

This is a fairly basic mailmerge, though you should consider changing some of the workbook's headings - timespans really aren't appropriate for that (e.g. you don't want to have to change the mailmerge main document just because someone decides a different timespan is needed).

A mailmerge cannot retrieve the font data - you have to do all the formatting in Word.

PS: Rather than linking to external websites, it is preferable for the content to be attached here - which you can do via the paperclip symbol on the 'Go Advanced' posting screen.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thanks for the reply. However I do not understand what you mean by timespan. Do you mean the workshops times which are indicated on the Excel sheet?

Precisely. You have a column headed with 12:45-1:20pm. You also have multiple columns with the same name for the header row.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Do you suggest that I just remove the time headings? Technically, I do not need the name of the headings in Word, just the information on each column

Also, how can I make it so that I can put several labels on one page?

No, you should keep the headings, but make them more meaningful (and accurate). Without them, your mailmerge setup & maintenance becomes much more difficult. As for outputting more than one record per page, use a label merge or a directory merge.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

I managed to insert 6 records onto one page. However, when I click on next record (technically going on to the next sheet), it shows me 5 of the same names as the previous page with only one new name.

All you are doing is previewing the merge, you need to finish it - using Finish & Merge...

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]