Word mail merge 255 characters

[Mike2502]

Hi all,

I've made the above work however, for my mail merge on word I get an error for 'String is longer than 255 characters'

As this is in a shared drive the path is longer than usual, is there any way around this? I've hid the path links for obvious reasons but see below

  ActiveDocument.MailMerge.MainDocumentType = wdFormLetters
ActiveDocument.MailMerge.OpenDataSource Name:="linkhere" _
, ConfirmConversions:=False, ReadOnly:=False, LinkToSource:=True, _
AddToRecentFiles:=False, _
WritePasswordDocument:="", Revert:=False, _
Format:=wdOpenFormatAuto, Connection:= _
"Provider=Microsoft.ACE.OLEDB.12.0;User ID=Admin;Data Source=linkhere;Mode=Read;Extended Properties=""HDR=YES;IMEX=1;"";Jet OLEDB:System database="""";Jet OLEDB:Registry Path="""";Jet OLEDB" _
, SQLStatement:="SELECT * FROM `Data$`", SQLStatement1:="", SubType:= _
wdMergeSubTypeAccess

 

[ashakantasharma]

You can try renaming the file/folders names to a shorter ones across the file systems to get rid of the same, if possible.

 

[Macropod]

Try deleting:

_
,  ConfirmConversions:=False, ReadOnly:=False, LinkToSource:=True, _
AddToRecentFiles:=False, _
WritePasswordDocument:="", Revert:=False

 

[Mike2502]

Try deleting:

_
,  ConfirmConversions:=False, ReadOnly:=False, LinkToSource:=True, _
AddToRecentFiles:=False, _
WritePasswordDocument:="", Revert:=False

Hi Paul

I'm getting the same error on this;

    ActiveDocument.MailMerge.MainDocumentType = wdFormLetters
    ActiveDocument.MailMerge.OpenDataSource Name:="location", _
        Format:=wdOpenFormatAuto, Connection:= _
        "Provider=Microsoft.ACE.OLEDB.12.0;User ID=Admin;Data Source=location;Mode=Read;Extended Properties=""HDR=YES;IMEX=1;"";Jet OLEDB" _
        , SQLStatement:="SELECT * FROM `PP$`", SubType:= _
        wdMergeSubTypeAccess

Is there anything I can trim out? Or would it work if I made a string with the location and put the string in the 'Location' fields above? If so how would one implement this into the sql?

Thanks!

 

[Macropod]

You might try having your IT people set up an alias for the filepath and use that.