J
jon
Hi everyone
i tried posting this on application errors but no-one
answered it so the gauntlet has been passed to you lot.
I recently set up an automatic mail merge by recording a
macro of the mailmerge then inserting my own code to save
the new document and close everything up again. My
problem is that when the recorded part of the macro runs
it causes a 'runtime error 5987' and says that there
isn't enough space on the disk and to save to another
disk. The thing is that there's about 32GB of free space
left and it's the same with any other drive. If anyone
has any solutions please, please help me.
thanks a lot, code is below...
ActiveDocument.MailMerge.OpenDataSource Name:= _
"F_I_L_E_N_A_M_E", ConfirmConversions:=False,
ReadOnly:=False, LinkToSource:=True, _
AddToRecentFiles:=False, PasswordDocument:="",
PasswordTemplate:="", WritePasswordDocument:="",
WritePasswordTemplate:="", Revert:=False, _
Format:=wdOpenFormatAuto, Connection:= _
"Provider=Microsoft.Jet.OLEDB.4.0;Password="""";
User ID=Admin;Data Source=F_I_L_E_N_A_M_E ;Mode=Read;
Extended Properties=""HDR=YES;IMEX=1;"";
Jet OLEDB:System database="""";Jet OLEDB:Registry
Path="""";Jet OLEDB
atabase ",
SQLStatement:="SELECT * FROM `Sheet1$`",
SQLStatement1:="", SubType:= _
wdMergeSubTypeAccess
i tried posting this on application errors but no-one
answered it so the gauntlet has been passed to you lot.
I recently set up an automatic mail merge by recording a
macro of the mailmerge then inserting my own code to save
the new document and close everything up again. My
problem is that when the recorded part of the macro runs
it causes a 'runtime error 5987' and says that there
isn't enough space on the disk and to save to another
disk. The thing is that there's about 32GB of free space
left and it's the same with any other drive. If anyone
has any solutions please, please help me.
thanks a lot, code is below...
ActiveDocument.MailMerge.OpenDataSource Name:= _
"F_I_L_E_N_A_M_E", ConfirmConversions:=False,
ReadOnly:=False, LinkToSource:=True, _
AddToRecentFiles:=False, PasswordDocument:="",
PasswordTemplate:="", WritePasswordDocument:="",
WritePasswordTemplate:="", Revert:=False, _
Format:=wdOpenFormatAuto, Connection:= _
"Provider=Microsoft.Jet.OLEDB.4.0;Password="""";
User ID=Admin;Data Source=F_I_L_E_N_A_M_E ;Mode=Read;
Extended Properties=""HDR=YES;IMEX=1;"";
Jet OLEDB:System database="""";Jet OLEDB:Registry
Path="""";Jet OLEDB
atabase ",SQLStatement:="SELECT * FROM `Sheet1$`",
SQLStatement1:="", SubType:= _
wdMergeSubTypeAccess