I have a parameter query set up to allow me to select records to use in a mail merge. I have the query and mail merge set up to run in a macro. What I want is to be able to automatically add the current date to a Date Run field in the table when the macro is run so that we can see which records have had Mail merges run on what date. Can someone help me please? I dont hink I can run an update query (to add the current date) and a select query (for the Mail merge fields together)
