[AccessD] Word mail merge code - Albert Kallal

[cjlabs]

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