It appears that the "master document" is going to be processed on individual PCs. In that case, I think that downloading the merge data source is the best solution. It might require some training, but doing a mail merge in MS Word is not a huge challenge.
You were thinking of using an ODBC connection as the data source? I don't know how you could possibly incorporate a user id into an MS Word master document (and not even into the document itself, but into the data source management) without a huge amount of programming. In fact, I think you'd wind up rewriting the merge engine in VBA before you were done. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.etudes-marche.com > -----Original Message----- > From: JugLugs [mailto:[EMAIL PROTECTED] > Sent: Wednesday, May 30, 2007 3:41 PM > To: mysql@lists.mysql.com > Subject: Re: True multi user? > > > mmm I think i need some sort of compromise here... > > Yes setting up a table called data with a userid is easily > done but can I > 'filter' these within the master document? - perhaps 'feed' > the document the > userid (somehow) and then with a bit of manipulation via document code > filter the result set ?? can i do that in a mailmerge ? > > Also i do have to consider that some users will be using > microsoft to do the > mailmerge but others will be using openoffice! > > I think this is one big can of worms - I think the only solution is to > export the data to a csv, have the user save the file to a > specified area > and filename and then use this (data.csv) as the datasource. > > i am still hoping there is a better way to :) > > Thanks, > > Juglugs > -- > View this message in context: > http://www.nabble.com/True-multi-user--tf3841867.html#a10881116 > Sent from the MySQL - General mailing list archive at Nabble.com. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
