Re: Mail Merge

Thanks Albert

looks super. I wll play around with it

BTW, what version of Access was that written for. Gel a compile error on

strExt = IIf(Application.Version <= 11, ".doc", ".docx")

Have replaces ir with
strExt = ".doc"

AK2 doesn't recognise Application.Version.

It does recognise Application.DBEngine.Version
which gives 3.6 but I have a feeling I should be expecting to see 10

Thanks again

Phil

"Albert D. Kallal" <PleaseNOOOsPAMmkallal@xxxxxxx> wrote in message
news:STUnl.41415$RJ7.14358@xxxxxxxxxxxxxxx
Perhaps you give my word merge sample a try?


You could go:

MergeAllWord "TempNewQuery"

(about one line of code to do your needed merge).

Turns out that word not only have trouble connecting to a mdb, or mde, but
often decides to launch another copy.

You can find my "super easy word" merge here:

http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

The problem is just that there is "too" many problems when you let word
try to connect to your database. Often if that query has any functions,
then again word can't use the query. If you have security set for your
database, then again problems arise. And if you don't use late binding in
your code..then again probems crop up when you move to a differnt
computer...(and on and on and on).

My merge sample solves these problems by forcing word to attach to a text
file...not ms-access.

So if someone else don't come up here with a post for a easy fix, my merge
sample is one possible way out of this problem...

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@xxxxxxx




.

Relevant Pages

  • Re: Mail Merge
    ... MergeAllWord "TempNewQuery" ... You can find my "super easy word" merge here: ... Often if that query has any functions, ... If you have security set for your database, ...
    (comp.databases.ms-access)
  • Re: MS Access with Linked tables Security Issue
    ... connect to SQL Server database with one Super ID that has all the super ... Dim dbs As Database, rs As Recordset, tdfAccess As TableDef ... Set dbsODBC = OpenDatabase ...
    (microsoft.public.access.forms)
  • Query Process not showing users when not Admin
    ... Firstly apologies if you've read this in similar newsgroups - I've got nowhere ... with it and perhaps someone in here won't have seen my query before... ... I'm writing a simple script that a user can run to show them how many ... As super it comes out like this: ...
    (microsoft.public.windows.server.security)
  • RE: rename a Web application
    ... \par It is an expected behavior that the old url still works. ... \par Regarding your query, you can consider creating a new web application with the new name and then attach the old content database to the newly created web application. ... \par When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from your issue. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: class super method
    ... confusing wxPython classes to have a consistent interface is where we also make the most use of super(), but our database wrappers also provide consistent functionality to all the dbapi cursors, no matter what the backend database may be. ...
    (comp.lang.python)