I got a trifle confused with my csv contents. If you are just adding dates then the CSV file need only contain one record ie all the dates required separated by commas. You then print as many copies as you need. However, if you wish to add different data to each copy as well as the dates then you would require the appropriate number of records, duplicating data as required.
You don't need to alter the base date from that required, the formula [base date cell]+n will give the required dates.
Merging two csv files ought to be possible in a spreadsheet by loading the first file into the spreadsheet and then pasting a copy of the second csv file to the right of the first. Mail merge can cope with the tags entered in the target document out of sequence.
Hope this helps----- Original Message ----- From: "Alan Adams" <alan@xxxxxxxxxxxxxxxx>
To: <davidpilling@xxxxxxxxxxxxx> Sent: Friday, June 25, 2010 7:05 PM Subject: [softwarelist] Re: Anyone into writing applets?
In message <5B947B5EA2FB46BE8AA51F8EB47FBDA3@DougLaptop> "Doug Thompson" <dougal99@xxxxxxxxxxxxxxx> wrote:Simply Create a CSV file of your dates from a spreadsheet using the datefunction to calculate your dates from your base date. The CSV file needs tocontain enough records to meet your needs. In this case the records wouldall be the same data, created using the $ copy option. Put mail merge tagsin your document as appropriate and then simply mail merge. I'm sure you could experiment with times as well.Hope this is of use and not teaching granny to suck.That's quite neat. So each line has one entry for each possible date, and there are enough lines for the number of date references. Lots more wouldn't matter. Obviously I need to make the base date one day before the earliest date, so day+1 becomes [merge 1], day2 = [merge 2] etc The downside, which I didn't mention, is that I would quite like to be able to mail-merge other things into similar documents, although not the pamphlet. I have never found a way to mail-merge two CSV files into one document. (I do have a VERY complex spreadsheet to produce the combined CSV in one case.)Doug ----- Original Message ----- From: "Alan Adams" <alan@xxxxxxxxxxxxxxxx> To: <davidpilling@xxxxxxxxxxxxx> Sent: Thursday, June 24, 2010 9:40 PM Subject: [softwarelist] Anyone into writing applets?I've got an application which seems to require a new applet - correct me please if one already exists. Each year I produce a 24-page handbook for a 2-week event, and the run-up period. The booklet is littered with dates, which are all a constant offset from a standard date - let's call it d-day. The first date in the calendar might therefore be d-7 i.e. a week before the reference date, and the last might be d+21, 3 weeks after the reference. It would be great if I could embed tags in the document for, say d-7, set up the reference date in some other form of tag, and have the printed document, and ideally the displayed document, embed the resulting date. A similar model to mail-merge would work. Of course there is then the issue of format - 24th June, 24Jun2010, Thu 24 June, 24/6/10, Thursday 24th etc. (I would guess that most of the logic, and a lot of the code, could also deal with h-hour to put times in. That's not so important to me - yet...) Anyone fancy a bit of programming? Although I do write stuff, I haven't investigated OPro internals. I don't even know whether this is possible as an applet, or whether it would require changes to the application. How are tags dealt with? -- Alan Adams, from Northamptonshire alan@xxxxxxxxxxxxxxxx http://www.nckc.org.uk/ To unsubscribe or subscribe goto: //www.freelists.org/list/davidpillingTo unsubscribe or subscribe goto: //www.freelists.org/list/davidpilling-- Alan Adams, from Northamptonshire alan@xxxxxxxxxxxxxxxx http://www.nckc.org.uk/To unsubscribe or subscribe goto: //www.freelists.org/list/davidpilling
To unsubscribe or subscribe goto: //www.freelists.org/list/davidpilling