See attached. When you start the mailmerge, connect it to the 'Course IDs' Worksheet.
Note: As coded, the Word Document and Excel Workbook need to be kept in the one folder.
The formats of the output tables are controlled by the \l and \b switches in the DATABASE fields. The parameters for the:
• \l switch are determined via Insert|QuickParts>Field: Database>GetData: SelectFile&Table>Table AutoFormat>Apply Special Formats to
• \b switch are defined at:
Field codes: Database field - Office Support and can also be determined via Insert|QuickParts>Field: Database>GetData: SelectFile&Table>Table AutoFormat>Formats to Apply