tell application “Adobe InDesign 2020”
activate
set version of script preferences to “5.0”
set user interaction level of script preferences to never interact
set enable redraw of script preferences to false
set properties of excel import preferences to {range name:importRange, table formatting:excel unformatted table}
--return properties of excel import preferences
open theTemplate --without showing window
tell document 1
save to xx & "flyer:InDesign files:" & theFileName & ".indd"
tell view preferences
try
set horizontal measurement units to picas
set vertical measurement units to picas
end try
end tell
tell parent story of text frame "Headline"
tell insertion point -1
set contents to theHeadline as string
end tell
tell paragraph 1
set applied paragraph style to "Primary Header"
end tell
end tell
tell parent story of text frame "Subheadline"
tell insertion point -1
set contents to theSubhead & return & promoCode & " " & expirationDate
end tell
tell paragraph 1
set applied paragraph style to "Page Subheader"
end tell
tell paragraph 2
set applied paragraph style to "Promo"
end tell
end tell
tell page 1
set myPlace to place alias (filePath as string) autoflowing yes without showing options
tell text frame 1
set label to "Table"
set geometric bounds to {15.916, 3.0, 58.5, 46.5}
end tell
end tell