S
slack7639
I can not get Publisher 97 to do Mail Merge with Excel 97. Here's what
happens:
Mail Merge / Open Data Source / PUBMERGE Out of memory.
Mail Merge / Create Publisher Address List / PUBMERGE Out of memory.
Mail Merge / Edit Publisher Address List / PUBMERGE Out of memory.
but, for some reason, Word 97 will do Mail Merge with Excel 97, no problem
.. . .
Publisher 97 System Requirements, and what I'm running:
386DX, 486DX: Pentium 4, 2.8 GHz
MS Windows 95: XP
6 MB RAM, 8 MB: 2 GB
C:\WINDOWS\system32\ . . . I have JET Engine DLL 5.1.2600.0
I am thinking that this this could be an issue with System 'Over'
Requirements that I have, like 2GB of memory, and Publisher 97 is not
designed for it.
I read on this page that some have a problem with Access 97 and XP, when
they have over 500 MB of RAM - but I don't have this problem, Access 97 works
fine for me, no idea why . . . still wondering why Word 97 can do Mail merge:
http://en.allexperts.com/q/Using-MS-Access-1440/MS-Access-97-Memory.htm
Answer
Yeah, there seems to be a problem with old versions of Access (97 and
before) with Windows XP when the box has more than .5 gigs of RAM, which I'm
guessing you do.
Real easy solution? Dump some RAM. But I know you won't want to do that.
Tougher solution? Make sure you have all the service packs for Office 97 (I
think there are two), and maybe update your Jet engine from 3.0 (what Access
97 uses) to 4.0 (what WindowsXP uses). It's that inconsistency that is the
root of the problem.
.. . .
What I've tried:
- - - - - - -
From this page at the top:
http://www.eggheadcafe.com/forumarchives/publisher/Jan2006/post25974240.asp
1/6/2006 7:42:14 AM Re: Mailmerge Out Of Memory
Have you tried to open your data from another program, such as Publisher 2003?
No, I only have Pub 97
This old article addresses Windows NT but it may help. PUB97: Publisher
Closes Publication if It Can't Read Data Source
http://support.microsoft.com/kb/167894/en-us
n/a - can't even get this far
The PubMerge.dll could be corrupt, might re-name it and do a re-install.
Although you are not getting page fault this article could help: PUB97:
Invalid Page Fault in Pubmerge.dll
http://support.microsoft.com/kb/161549/en-us
Both of mine were the same, in C:\WINDOWS\system32 and on the CDROM
MSJINT32.DLL, 35 KB, 8/6/1996 12:00 AM
Could be a printer thing too. Have you changed printers?
No
Do you get the same message in safe mode?
Yes
Disable your printer before opening Publisher, see if that works.
No
Have you tried the compatibility mode?
Yes. Right-clicking on the program itself, MSPUB.EXE . . . Compatibility
tab / and checked 'Run this program in compatibility mode for:' Windows 95 -
didn't work. Then I clicked on 'Learn more about program compatibility' - I
went through many combinations in this Wizard - didn't work
PUB97: How to Obtain Publisher 97 Knowledge Base HTML Help File
http://support.microsoft.com/kb/185798/en-us
Got it. Do not see anything that addresses this.
- - - - - - -
De-installed in Safe Mode: Office 97, and Pub 97
Re-installed in Safe Mode: Office 97, and Pub 97
Re-installed in Safe Mode: SR1 and SR2b
In the "About" of Excel, Word, and Access, it says that they have SR-2 after
the re-install, even when I had not re-done that yet
Publisher 97 does not say that it has SR-2 after the re-install. Maybe SR-2
does not apply to it?
- - - - - - -
Are your MDAC components current? Microsoft Data Access Components -
includes ADO, ODBC and OLE DB. In the below article is a link to the
component checker. How to check for MDAC version:
http://support.microsoft.com/?kbid=301202
It says that I have this, which looks current:
MDAC 2.8 SP1 ON WINDOWS XP SP2
- - - - - - -
From this page at the bottom:
http://itknowledgeexchange.techtarget.com/itanswers/publisher-97/
"I have seen similar errors with older software on newer OS’s and the
problem was that the TEMP environment variable was pointing to Cocuments
and Settingsblahblahblah. I changed the environment variable on an offending
machine to point to C:Temp (after creating that folder) and everything worked
well."
In my System Properties / Advanced tab / Environment Variables at the bottom
/ I changed the "User variable for Administrator" from the long sub-directory
( %USERPROFILE%\Local Settings\Temp ) to:
TEMP (Value = C:\Temp)
TMP (Value = C:\Temp)
.. . . didn't work . . . any downside to leaving it like this? . . .
.. . . I like to clear out files in C:\Temp occasionally . . . a question I
have now is if it's ok to delete all the files there, and in the long
sub-directory: %USERPROFILE%\Local Settings\Temp ? I am thinking that the
environment for Administrator in C:\Temp would be ok to delete, but the the
System uses the long sub-directory temp file area, better leave that alone.
happens:
Mail Merge / Open Data Source / PUBMERGE Out of memory.
Mail Merge / Create Publisher Address List / PUBMERGE Out of memory.
Mail Merge / Edit Publisher Address List / PUBMERGE Out of memory.
but, for some reason, Word 97 will do Mail Merge with Excel 97, no problem
.. . .
Publisher 97 System Requirements, and what I'm running:
386DX, 486DX: Pentium 4, 2.8 GHz
MS Windows 95: XP
6 MB RAM, 8 MB: 2 GB
C:\WINDOWS\system32\ . . . I have JET Engine DLL 5.1.2600.0
I am thinking that this this could be an issue with System 'Over'
Requirements that I have, like 2GB of memory, and Publisher 97 is not
designed for it.
I read on this page that some have a problem with Access 97 and XP, when
they have over 500 MB of RAM - but I don't have this problem, Access 97 works
fine for me, no idea why . . . still wondering why Word 97 can do Mail merge:
http://en.allexperts.com/q/Using-MS-Access-1440/MS-Access-97-Memory.htm
Answer
Yeah, there seems to be a problem with old versions of Access (97 and
before) with Windows XP when the box has more than .5 gigs of RAM, which I'm
guessing you do.
Real easy solution? Dump some RAM. But I know you won't want to do that.
Tougher solution? Make sure you have all the service packs for Office 97 (I
think there are two), and maybe update your Jet engine from 3.0 (what Access
97 uses) to 4.0 (what WindowsXP uses). It's that inconsistency that is the
root of the problem.
.. . .
What I've tried:
- - - - - - -
From this page at the top:
http://www.eggheadcafe.com/forumarchives/publisher/Jan2006/post25974240.asp
1/6/2006 7:42:14 AM Re: Mailmerge Out Of Memory
Have you tried to open your data from another program, such as Publisher 2003?
No, I only have Pub 97
This old article addresses Windows NT but it may help. PUB97: Publisher
Closes Publication if It Can't Read Data Source
http://support.microsoft.com/kb/167894/en-us
n/a - can't even get this far
The PubMerge.dll could be corrupt, might re-name it and do a re-install.
Although you are not getting page fault this article could help: PUB97:
Invalid Page Fault in Pubmerge.dll
http://support.microsoft.com/kb/161549/en-us
Both of mine were the same, in C:\WINDOWS\system32 and on the CDROM
MSJINT32.DLL, 35 KB, 8/6/1996 12:00 AM
Could be a printer thing too. Have you changed printers?
No
Do you get the same message in safe mode?
Yes
Disable your printer before opening Publisher, see if that works.
No
Have you tried the compatibility mode?
Yes. Right-clicking on the program itself, MSPUB.EXE . . . Compatibility
tab / and checked 'Run this program in compatibility mode for:' Windows 95 -
didn't work. Then I clicked on 'Learn more about program compatibility' - I
went through many combinations in this Wizard - didn't work
PUB97: How to Obtain Publisher 97 Knowledge Base HTML Help File
http://support.microsoft.com/kb/185798/en-us
Got it. Do not see anything that addresses this.
- - - - - - -
De-installed in Safe Mode: Office 97, and Pub 97
Re-installed in Safe Mode: Office 97, and Pub 97
Re-installed in Safe Mode: SR1 and SR2b
In the "About" of Excel, Word, and Access, it says that they have SR-2 after
the re-install, even when I had not re-done that yet
Publisher 97 does not say that it has SR-2 after the re-install. Maybe SR-2
does not apply to it?
- - - - - - -
Are your MDAC components current? Microsoft Data Access Components -
includes ADO, ODBC and OLE DB. In the below article is a link to the
component checker. How to check for MDAC version:
http://support.microsoft.com/?kbid=301202
It says that I have this, which looks current:
MDAC 2.8 SP1 ON WINDOWS XP SP2
- - - - - - -
From this page at the bottom:
http://itknowledgeexchange.techtarget.com/itanswers/publisher-97/
"I have seen similar errors with older software on newer OS’s and the
problem was that the TEMP environment variable was pointing to Cocuments
and Settingsblahblahblah. I changed the environment variable on an offending
machine to point to C:Temp (after creating that folder) and everything worked
well."
In my System Properties / Advanced tab / Environment Variables at the bottom
/ I changed the "User variable for Administrator" from the long sub-directory
( %USERPROFILE%\Local Settings\Temp ) to:
TEMP (Value = C:\Temp)
TMP (Value = C:\Temp)
.. . . didn't work . . . any downside to leaving it like this? . . .
.. . . I like to clear out files in C:\Temp occasionally . . . a question I
have now is if it's ok to delete all the files there, and in the long
sub-directory: %USERPROFILE%\Local Settings\Temp ? I am thinking that the
environment for Administrator in C:\Temp would be ok to delete, but the the
System uses the long sub-directory temp file area, better leave that alone.