Mark Whittinghill
mwhittinghill at symphonyinfo.com
Tue Mar 11 15:41:01 CST 2003
I don't know if this is relevant, but what we do here with Mail Merge is export the data as a text file from Access, then use that text file as the source document for the Word mail merge. Mark Whittinghill Symphony Information Services Minneapolis, Minnesota Email: mark at symphonyinfo.com Phone: 612-333-1311 ----- Original Message ----- From: "John Bartow" <jbartow at earthlink.net> To: <accessd at databaseadvisors.com> Sent: Tuesday, March 11, 2003 3:32 PM Subject: RE: [AccessD] Word Automation > Hi Brett, > I'm just putting out feelers here. I don't remember this being discussed > before and I usually preview at least the subject lines of AccessD mail but > it could've been one of those subject lines that never dies where the > discussion just keeps changing. I'll check the archives. > > Mail Merge does work good if you're on the same versions of Word and Access. > > Otherwise it causes some (minor to me) irritations that are not to well > recieved by end-users. I sell these apps to customers and they don't like > all kinds of dialog boxes popping up, it "scares them" :o) > > -If you have W2k and A97 it will intially want to convert the DB. After you > say no the first time you're OK but a lot of end users just freak out! > -It will pop up another instance of the Access DB where the merge data is > coming from (sometimes the extra process closes with Word and somtimes not) > > -W97 and W2k can't read an A97 MDE data source it has to be a MDB > -W97 can't read the A2k format > > so for these issues you have to jump through all kinds of extra hoops > converting the data to a format W97 can read. > > I wish I could jsut make them all have the same version but I'm not that > good... > > JB > > -----Original Message----- > From: accessd-admin at databaseadvisors.com > [mailto:accessd-admin at databaseadvisors.com]On Behalf Of Brett Barabash > Sent: Tuesday, March 11, 2003 2:42 PM > To: 'accessd at databaseadvisors.com' > Subject: RE: [AccessD] Word Automation > > > I've seen this discussed before on this list, and wondered why people are > rolling their own mail merge routines? Personally, I find bookmarks > cumbersome to work with and mail merge has always worked well for me with > minimal effort. > > > -----Original Message----- > From: John Bartow [mailto:jbartow at earthlink.net] > Sent: Tuesday, March 11, 2003 10:38 AM > To: AccessD > Subject: [AccessD] Word Automation > > > Bryan (or any other word gurus out there), > Can you think of a way to elegantly replace my (word automation) mail merges > with your bookmark style automation? > > Basically use bokmarks and some looping scheme to dump addresses it a > prepared letter/envelope, creating one document with all of the merged > letters/envelopes. > > JB > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >