D
Dixie
I have a question on speed of mailmerge from Access to Word. I have an
application that merges data from an Access application via automation to
Word templates. It has been operating by transferring a text file to a
location on the local drive and having that as a data source in the
appropriate letter template. It opens the template which then looks for its
data source and merges.
It has been working well, but I am having a few problems that made me think
I would be better having Access send the location of the query that produces
the merge data and have no data source in the template.
This also works, but what is very obvious is the slowness of the merge
compared to when it has a text file as a data source. I can see each step
of the merge in 'slow motion' with the status bar telling me what is
happening.
My questions.
1. Is this method just naturally slow or can I somehow make it faster?
2. If it can be made to be faster, how?
3. Is it more reliable to send the data like this
objWord.MailMerge.OpenDataSource _ Name:="C:\Program Files\Microsoft
" & _ "Office\Office\Samples\Northwind.mdb", _ LinkToSource:=True, _
Connection:="TABLE Customers", _ SQLStatement:="SELECT * FROM
[Customers]" ' Execute the mail merge. objWord.MailMerge.Executeor am I
better off sticking with the DoCmd.TransferText approach?
I am interested to see what people think.
dixie
application that merges data from an Access application via automation to
Word templates. It has been operating by transferring a text file to a
location on the local drive and having that as a data source in the
appropriate letter template. It opens the template which then looks for its
data source and merges.
It has been working well, but I am having a few problems that made me think
I would be better having Access send the location of the query that produces
the merge data and have no data source in the template.
This also works, but what is very obvious is the slowness of the merge
compared to when it has a text file as a data source. I can see each step
of the merge in 'slow motion' with the status bar telling me what is
happening.
My questions.
1. Is this method just naturally slow or can I somehow make it faster?
2. If it can be made to be faster, how?
3. Is it more reliable to send the data like this
objWord.MailMerge.OpenDataSource _ Name:="C:\Program Files\Microsoft
" & _ "Office\Office\Samples\Northwind.mdb", _ LinkToSource:=True, _
Connection:="TABLE Customers", _ SQLStatement:="SELECT * FROM
[Customers]" ' Execute the mail merge. objWord.MailMerge.Executeor am I
better off sticking with the DoCmd.TransferText approach?
I am interested to see what people think.
dixie