Search results

  1. M

    SQLStatement in Connection Statement

    Hi, I have MS Access tool used for mail merge. Mail Merge is done using different letter templates e.g all records in the DB with Code A1 go to a letter template A1, Code A2 records are mail merged to template A2 etc. To perform the mail merge I have created as many queries in Access as there...
  2. M

    Filter through connection

    Hi good people, I have records a fCriteria table that I am connecting to using the code below. How can I filter records in the table using based on Letter_Code field ? E.g Filter all records where the code is LTRPLA found in Letter_Code field. Regards, almacjnr
  3. M

    Server cannot be found error

    Teh code below is used for doing a mail merge. It works well the 1st time but spits out an error that the database cannot be found when invoked the 2nd time. Why would this be happening ? Thank you in advance for the help.
  4. M

    Save a merged doc from Access

    Hi, The code attached is used for performing a mail merge (which it does) by creating a document and closes the source/template document. What code can I add to close and save the merged document in read only in word or even better in pdf ? Will greatly appreciate your help. Thank you
  5. M

    Mailmerge

    Hi, Can any one help enhance the code below to 1. send the result of the mailmerge to pdf 2. Save the results to a specific location Regards, Chris
  6. M

    IMporting fixed width text file into a database

    Hi, I am trying to implement a system that will import data from a text file whose data is in a fixed width format i.e Field 1 is from 1-2, field 2 is from 13-20 etc I have inserted message boxes to confirm that the code is reading the data but my problem lies in picking the fields and in the...
Back
Top Bottom