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?