SSQLWhere = sSQLModel ' never replace in the model SSQLModel = " Where ( AssignLtrType = 'T1' or AssignLtrType = 'T2' ) " (1) What I use is the WHERE clause (on the OpenDataSource, you probably don't need all those options) ' setup the SQLĭim sSQLModel As String, sSQLWhere As String I have uploaded the data I am trying to work on: I am running Office 2013 and so far I have the code in bits and pieces and had no luck when trying to run it. (3) This file should be saved in PDF format. (2) Run mailmerge without displaying Microsoft Word and only displaying the "Save As" dialog where the user can select where to save the file. (1) Select recepients by filtering the "Status" column, so if the user pressed the first button, it will run the mail merge only for records with "P" in the status column. This word template file called "MyTemplate" will be in the same directory as the excel file. I have created this work template for the fields. I want to run a mailmerge using the below buttons on the user form: Records marked as "Not Completed" will have the letter "N" in the status column. Records marked as "Completed" will have the letter "Y" in the status column. Records marked as "In Progress" will have the letter "P" in the status column. I have created a Userform where you can flag records as "In Progress", "Completed", and "Not Completed".
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |