Mailmerge Excel and TXT file & save to variable file names
- Posted:
- Proposals: 2
- Remote
- #4036
- Archived
have already sent a proposal. 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.
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.
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.