Mailmerge Excel and TXT file & save to variable file names

  • Posted
  • Proposals 2
  • Remote
  • #4036
  • Archived
Simon S.Kyle S. have already sent a proposal.
  • 0

Description

Experience Level: Expert
I have an Excel file which has two columns (Make & Model) and currently 12,500 records (and steadily growing). I wish to "mailmerge" this with a text file (which I could obviously do in MS Word). However, for each unique record processed I need to resulting merged document to be saved and named according to the variables in the records.

For example, The text file (which will ultimately be a web page) may contain:-
<html>
We can supply you with a remote control for your [make] [model] for only £100
</html>

The [make] and [model] should be populated from the excel file and the resulting document should be saved on the basis of remote-control-[make]-[model].htm (for example remote-control-matsui-1436.htm)

By using a single text file as a template for the web pages that is just populated from the excel spreadsheet, I can amend the design of the page once and just re-run the "merge" to re-create the pages. Any new models records added will be taken care of when the process is re-run.

Clarification Board

    There are no clarification messages.