[AccessD] Word mail merge code - Albert Kallal

[jack drawbridge]

Carolyn,

You could post your question/issue on UA. I'm sure Albert is active enough
to get back to you fairly quickly.

jack

On Mon, Jan 30, 2017 at 1:19 PM, cjlabs <cjlabs at att.net> wrote:

> As far as a can tell from his notes, he changed the extension from .txt to
> .888 due to some conflict that occurred with the option to turn off file
> extensions.
>
> The file itself is comma delimited.
>
>
> Jack -- I'll check the UtterAccess links.   Maybe I was using an old email
> address.
>
>
> Thanks
> Carolyn Johnson
>
>
>
> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
> Susan Harkins
> Sent: Monday, January 30, 2017 12:15 PM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] Word mail merge code - Albert Kallal
>
> What is an .888 file? Has it always had that extension?
>
> Susan H.
>
> > Merge.888 is the data file for the merge.
> >
> >
> >
> >
> >
> > If I choose Open, Word crashes.   I get an Automation error in procedure
> > MergeWord of his WordCode sub.
> >
> >
> >
> >
> >
> > If I chooseRecover Data, Word shows empty records (despite the data
> > being in the file).
> >
> >
> >
> >
> >
> > If I step through the procedure, it crashes on   WordDoc.MailMerge.
> OpenDataSource
> > _
> >
> >         Name:=strMergeDataFile, _
> >
> >         ConfirmConversions:=False, _
> >
> >         ReadOnly:=False, LinkToSource:=True, AddToRecentFiles:=False,
> > _
> >
> >         PasswordDocument:="", PasswordTemplate:="",
> > WritePasswordDocument:="", _
> >
> >         WritePasswordTemplate:="", Revert:=False, Format:=0, _
> >
> >         Connection:="", SQLStatement:="", SQLStatement1:=""
> >
> >
> >
> > Specifically when it calls the function  strMergeDataFile  which
> > returns the path to the data file (in the Temp folder).
> >
> >
> >
> >
> >
> > Is anyone using Kallal’s code and made the changes to work in more
> > recent versions of Office?
> >
> >
> >
> > I realize there are many ways to create a merge document in Word, but
> > I would prefer to stick with what I am using if it will work.
> >
> >
> >
> > I emailed Albert Kallal but received no response.
> >
> >
> >
> >
> >
> >
> >
> > Thanks
> >
> > Carolyn Johnson
> >
> > St Louis, MO
> >
> > --
> > 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
>
>
> --
> 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
>