If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Mail merge macro from xp to vista
Hi
I have a macro that does a mail merge from an excel 2007 workbook to word- mailing labels for a mailshot. This is on an XP pro PC. I have copied it over to run on a Vista machine running Word 2007. It fails to excute as it can't connect to data source. I re wrote the file path to the source on the vista machine. and rechecked it several times. Here is the bit that works on XP: "C:\Documents and Settings\Fred\My Documents\Friends labels\friends merge.xls" _ , ConfirmConversions:=False, ReadOnly:=False, LinkToSource:=True, _ AddToRecentFiles:=False, PasswordDocument:="", PasswordTemplate:="", _ WritePasswordDocument:="", WritePasswordTemplate:="", Revert:=False, _ Format:=wdOpenFormatAuto, Connection:= _ "Provider=Microsoft.ACE.OLEDB.12.0;User ID=Admin;Data Source=C:\Documents and Settings\Fred\My Documents\Friends labels\friends merge.xls;Mode=Read;Extended Properties=""HDR=YES;IMEX=1;"";Jet OLEDB:System database="""";Jet OLEDB:Registry Path="""";Jet OLEDB:E" _ , SQLStatement:="SELECT * FROM `Friends$`", SQLStatement1:="", SubType:= _ wdMergeSubTypeAccess On the vista machine I copy the excel file to C drive andchange code to file path: C:\friends merge.xls I can't understand why it can't connect. It it a vista versus XP issue? Help appreciated |
#2
|
|||
|
|||
Mail merge macro from xp to vista
1. Have you made the registry change described in
http://support.microsoft.com/kb/825765/en-us on both machines? 2. Can we assume that you are changing the path in both the Name and Connection parameters? (FWIW, in this case I think you should be able to do just yourobjname.MailMerge.OpenDataSource _ Name:="C:\Documents and Settings\Fred\My Documents\Friends labels\friends merge.xls", _ SQLStatement:="SELECT * FROM `Friends$`" or yourobjname.MailMerge.OpenDataSource _ Name:="C:\friends merge.xls", _ SQLStatement:="SELECT * FROM `Friends$`" and omit all the other parameters) -- Peter Jamieson http://tips.pjmsn.me.uk "kim" wrote in message ... Hi I have a macro that does a mail merge from an excel 2007 workbook to word- mailing labels for a mailshot. This is on an XP pro PC. I have copied it over to run on a Vista machine running Word 2007. It fails to excute as it can't connect to data source. I re wrote the file path to the source on the vista machine. and rechecked it several times. Here is the bit that works on XP: "C:\Documents and Settings\Fred\My Documents\Friends labels\friends merge.xls" _ , ConfirmConversions:=False, ReadOnly:=False, LinkToSource:=True, _ AddToRecentFiles:=False, PasswordDocument:="", PasswordTemplate:="", _ WritePasswordDocument:="", WritePasswordTemplate:="", Revert:=False, _ Format:=wdOpenFormatAuto, Connection:= _ "Provider=Microsoft.ACE.OLEDB.12.0;User ID=Admin;Data Source=C:\Documents and Settings\Fred\My Documents\Friends labels\friends merge.xls;Mode=Read;Extended Properties=""HDR=YES;IMEX=1;"";Jet OLEDB:System database="""";Jet OLEDB:Registry Path="""";Jet OLEDB:E" _ , SQLStatement:="SELECT * FROM `Friends$`", SQLStatement1:="", SubType:= _ wdMergeSubTypeAccess On the vista machine I copy the excel file to C drive andchange code to file path: C:\friends merge.xls I can't understand why it can't connect. It it a vista versus XP issue? Help appreciated |
#3
|
|||
|
|||
Mail merge macro from xp to vista
The root folder of the C: drive is probably not available to code when
running Vista. Try moving the folder to c:\ProgramData -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "kim" wrote in message ... Hi I have a macro that does a mail merge from an excel 2007 workbook to word- mailing labels for a mailshot. This is on an XP pro PC. I have copied it over to run on a Vista machine running Word 2007. It fails to excute as it can't connect to data source. I re wrote the file path to the source on the vista machine. and rechecked it several times. Here is the bit that works on XP: "C:\Documents and Settings\Fred\My Documents\Friends labels\friends merge.xls" _ , ConfirmConversions:=False, ReadOnly:=False, LinkToSource:=True, _ AddToRecentFiles:=False, PasswordDocument:="", PasswordTemplate:="", _ WritePasswordDocument:="", WritePasswordTemplate:="", Revert:=False, _ Format:=wdOpenFormatAuto, Connection:= _ "Provider=Microsoft.ACE.OLEDB.12.0;User ID=Admin;Data Source=C:\Documents and Settings\Fred\My Documents\Friends labels\friends merge.xls;Mode=Read;Extended Properties=""HDR=YES;IMEX=1;"";Jet OLEDB:System database="""";Jet OLEDB:Registry Path="""";Jet OLEDB:E" _ , SQLStatement:="SELECT * FROM `Friends$`", SQLStatement1:="", SubType:= _ wdMergeSubTypeAccess On the vista machine I copy the excel file to C drive andchange code to file path: C:\friends merge.xls I can't understand why it can't connect. It it a vista versus XP issue? Help appreciated |
Thread Tools | |
Display Modes | |
|
|