[AccessD] Word mail merge code - Albert Kallal

[jack drawbridge]

Carolyn,

Albert is active on UtterAccess.

I see some links to his merge at
http://www.utteraccess.com/forum/index.php?showtopic=2037642&view=findpost&p=2602716

http://www.utteraccess.com/forum/index.php?showtopic=2035844&view=findpost&p=2589379

Good luck.

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

> I had been using Albert Kallal’s mail merge code for years (since 2003 or
> so), but it does not work in Office2010.   The last version I know that it
> was working was 2003.
>
>
>
> I get an error from Word  “The document ‘merge.888’ caused a serious error
> the last time it was opened.  You may continue opening it or perform data
> recovery by clicking ‘Recover Data’. Clicking ‘Recover Data’ will extract
> text of your document but all formatting and pictures will be lost.”
>
>
>
> 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
>