We’ve created an hta template file. Within this file we want to replace the recurring varLocation, varModel, etc variables with the live data. So the number of rows will vary depending on the source data. We’re able to do this by embedding the entire html code in an Access module. We are then outputting this into an Outlook email. That process works perfectly.
Code:
| Location | Model | SN | PrevExpire | BeginDate | EndDate | WarrPrice |
| varLocation | varModel | varSn | varPrevExpire | varBeginDate | varEndDate | varWarrantyPrice |
| TOTAL: | varTotalWarrSupport |
However, what we’d prefer to do is to simply read the hta’s applicable table row of variables and replace with rows of live data. The reason we don’t want to embed everything is that we are planning an interface where the user can select from a list of templates to use.
Thank you,
Ken
