Thread: [Solved] Generating Letters from Excel List
View Single Post
 
Old 10-13-2024, 07:59 PM
macropod's Avatar
macropod macropod is offline Windows 10 Office 2016
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
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
Assuming your second screenshot is what you want in terms of table formatting, you can get that result with the switches:
\l "36" \b "187" \h
and with the SELECT FROM statement written as:
SELECT [#] AS FER, `Year`, [InstrumentNo ] AS `'Instrument No'`, [DATE] AS`'Date'`, `Terms`, `CCY`, Format([Amount],'0') AS `Amount` FROM

As for the font used for the table, that is controlled by whatever font is applied in your mailmerge main document's Normal Style.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote