Back to all jobsMailmerge Excel and TXT file & save to variable file names Add to shortlist
Client Details
- Member Since: Sep 2008
- Last Login: 25 Nov 2008
- Jobs Posted: 1
- Jobs Awarded: 1
- Paid out: $274
Category:IT/Web/Programming > Application development
ID:4036
Title:Mailmerge Excel and TXT file & save to variable file names
Location:Anywhere
Job Description
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.
Job Budget
Type:Fixed Price
Budget:Up to £250 (Approx Up to $392)
Additional Information
Attached Files: None
Bidding ends:Bidding Closed
Job Posted:24/09/2008 17:22
Clarification Board
D. T. on 25/09/2008 11:35To clarify, I am looking for a program to be written.
This needs to read the text file and excel (which I can put into csv or access if easier) file to populate the text file with the fields from the excel file and then save each page to a new file to be named according to the fields in the xls file.
For example, if the xls file were to contain only 2 records such as "Bush 6690D" and "Matsui 1436" I would like the data to be merged into the text file so that for the first record wherever it said <make> Bush was inserted and likewise for <model> 6690D was inserted, then the file saved as "Remote-Control-Bush-6690D.htm" and then the process repeated for the second record being merged into the text file and saving a file called "Remote-Control-Matsui-1436.htm"
Please note that there are currently 12,500 records and it is slowly increasing.
Y. W. on 24/11/2008 19:15You must have got this job done already. If you require further help, I would be quite delighted to further enhance your requirement.
thanks
Yasantha
Here are some practical tips on staying safe
- Never pay any money to Clients and or provide sensitive details like your Bank information, Credit Card or Passwords
- Never accept a Job if you have been directed away from PeoplePerHour to another website
- Be cautious when providing your personal contact details (email, telephone number, instant message ID etc) before your Bid is accepted
- If you have been asked to send samples, put a watermark on them or send low resolution examples to avoid being exposed and not getting paid
- Don’t start work before your Bid is accepted and your Escrow deposit is made
- Keep your Escrow account topped up and ensure that you use the Private Message Board to track all pertinent details about the Job e.g. timelines, deliverables etc
- Before you supply final works to Clients, ensure you have adequate funds in Escrow
Remember: if something looks too good to be true, it probably is!
If you are in doubt of the legitimacy of a Job and or Client, let us know by Reporting the Job.
For further support on preventing and reporting fraud please contact the UK’s National fraud reporting centre at http://www.actionfraud.org.uk/ or outside the UK Fraud Watchers at {fraudWatchers}
United Kingdom
$
£ GBP
€ EUR
