[AccessD] Word Automation

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
>




More information about the AccessD mailing list