Year Book

[kxv2020]

Hi

 

Last year, I embarked on a small project for Sixth Form Leavers and produced an Access database [flat file] and front end in Delphi. That all worked really well and we mail merge all the data in a nice big word document which created a Year Book!

 

However the program was only avaliable in school as we don't have remote desktop. And the database was flat file as I you can't seem to do Relational Mail Merge in Word... [but SIMS.net does some how!!!??]

 

My question is... is there a simple but good way to create a database on the web, maybe use PHP, [not sure] and extract the data and mail merge into Word. It would be nice to mail merge relational data as Sims does.

 

Thanks

[alan-d]

Would coppermine do it?

[mac_shinobi]

since you originally mail merged the data into word, wouldnt it be easier if you just rename the images with something that relates to the students record so that you can use ASP or PHP to pull out the info from the DB and then just load the image based on say there first name or ID in the db ?

[kxv2020]

I will have a look at coppermine ... looks good

 

But... I think i might not off explained myself; the kids fill in details about stuff in categories... with a paragraph of text e.g. Interests & Hobbies, Most Mememborable Moments, Ambitions, etc...

 

That gets merged together with their picture. We then Merge into Word and send it to a professional printers.

 

Have a great Christmas!!

[mac_shinobi]

If you had the database in a folder that you have access to , couldnt you just point word to that database on the server and merge it that way ?