Search results for query: *

Wouldn't you believe it? As soon as I sent my last post I twigged that the answer was to not use Private Sub MailMergeApp_MailMergeAfterRecordMerge(ByVal doc As Document) but to use: Private Sub MailMergeApp_MailMergeAfterMerge(ByVal doc As Document, ByVal DocResult As Document) Obvious...

The code is as follows: In the Word Document Option Explicit Dim MergeApp As New QubeClass Sub Document_Open() Set MergeApp.MailMergeApp = Word.Application End Sub In my ClassModule Public WithEvents MailMergeApp As Word.Application Public intTableCount As Integer Public intTableMax As...

The VBA macro code

I am performing a mail merge from our corporate Admin system which is exporting 2 levels of data, the second the child records of the first. To enable this to work I have exported the child level data as concatenated merge fields with a return character between rows. These merge fields are put...

I want to be able to find out what a users temp directory is so that I can populate batch and parameter files there and then run the batch file to start another application. I am happy with sending output to these files and running the batch file, but I can't work out how to populate a variable...

Does anybody know if it is at all possible to send OLE links from Access to a mail merge document? Scenario: I have a database with with stock codes of manufacturing items, some of which have diagrams attached. I produce a manufacturing report which has one item per sheet to be used on the...

Thanks tb, that was the last 10% I required - just need to try it out now.

This has answered 90% of a question that I had, but can you help with the remaining 10%? What is the file name for the Microsoft DTSPackage Object Library, as it is not in my reference list and I need to go browsing for it? Thanks Chris

You will be pleased to know that the answer is yes, it can be done, but it is not straight forward. You will need a form, set up for form view for the order head details with relevant buttons (such as "Done") on and a sub-form in datasheet view for the order lines. As part of the form load...