if your marketing text is relatively straightforward (e.g., single block of text per item, not requiring complex line breaks or multiple extended text codes).
* How to do it:
* Go to the Extended Text Header page (search for it).
* Use the "Open in Excel" or "Edit in Excel" action.
* In the Excel add-in pane, you'll need to add the Extended Text Line table. You might also need to filter or select the correct Table Name (which would be "Item").
* You'll typically need to populate fields like:
* Table Name (e.g., Item)
* No. (Item No.)
* Language Code (e.g., "" for blank/default, or EN-US, etc.)
* No. Of Lines (This can be tricky; often it's the number of physical lines you will have in the text)
* Description (This is the primary field for the text on the header)
* Extended Text Code (If you use different codes for different types of marketing text)
* On the Extended Text Line table, you'll enter the actual Text content and the Line No..
* Once your Excel sheet is ready with all 2800 items and their corresponding text, use the "Publish" button in the Excel add-in.
