mailmerge | Mail Merge Using R Markdown Documents and 'gmailr

I am creating an Access 2019 database for small family business (dog breeding) so I setup some tables containing all details on the dogs and the owners. Just to give an idea (simplistic description of the situation):

I have written enough PS code to go through a list of displayNames (e.g "John Smith", "Taylor Hanson" - all stored on seperate lines of a txt file) to spit back enough data into another text file that can be used for mailmerge etc. Convincing thousands of employees to simply update Windows is like breaking stones! It has to be automatted to some degree...

Here is the code... the functions that let the user open a specific text file and later save are out of view...

I have a textBox in my Word Document, whose text is automatically populated through MailMerge - (the <> one in the below pic).

The shape name of the TextBox is namebox (I got this from Home > Editing > Selection Pane)

I was wondering if it's possible to change the font-size of this particular textBox - The textBox by default has a fontSize of 11, and I should decrease it to 10, depending on a variable's character-length (if its longer than 32 chars or not), so It could fit longer text more easily.

I have tried building some code myself, but I am getting a compilation error of 'variable not defined' on the namebox word.

Here is where I inserted the textbox:

Usually in java you can declare an instance variable then initialize it inside the constructor or inside a method.

But When i tried to do that in C# it gave me an error saying it needs to be a static variable.

In this image I declared an instance variable of MailMerger object then I initialized it inside the constructor. But when I tried to use the instance, it gave me an error asking for it to be static.

Can anyone please explain to me the reason behind that please? Thank you in advance.

I've built an access database that populates a table and then opens several Word mail merge templates, generates merged documents, and saves them. The relevant portion of the code gets or creates a Word application object, opens a merge template as a document object, runs the mail merge, and closes the template. It then looks for the merge output, makes that the active document, saves as (following a filenaming schema), and closes it. It then quits Word if no other documents are open, and releases the document and application objects.

Following an MS update that installed last week, this all works great once, but on the second runthrough, the generated merge document stops responding after it is made the active document. I've hit the Google hard to see if I can find an explanation or workaround, with no luck. Anyone have any ideas?

Relevant code:

I'm creating a word document using mailmerge in word and I need to show a block of word depending on a conditional var:

I a newbie to MS Access and VBA Code, but I have been handling well my needs. The code posted bellow is the only way I got my Click Event working. In order to printout current record from multiple tables (mail merge) it's required that some fields are filled. So before the actual printout code I inserted the following code. Is there a better way to do it? It just doesn't feel right the way I did it.

Long story short - I'm on a different laptop, and it is a work laptop where I am probably not administrator level. With that, I installed python, then pandas, numPY, pyodbc, docx-mailmerge and instead of doing "pip install" I did "py -m pip install ..." to get those in because just "pip install" didn't work.

I've been tweaking the routine that worked on my dead laptop, and finally got it to run to the end. My routine imports an access database, reads in the information and parses the rich text field to remove the html tags, and writes the data out to a word template and creates a new word document.

When it reaches the end of the commands, I get the lines

Traceback (most recent call last): File "", line 1, in ModuleNotFoundError: No module named 'py11.py'; 'py11' is not a package

If I try to do "import py11.py" again, I just get those lines. I thought it might be having problems with writing a file to somewhere other than a c: drive where the word template was, so I changed them both to be in the document directory, and I looked at the current directory, and it is where it should be. I currently am exiting out of python, and getting back in and then I can run this one time, and start getting the traceback messages again. TIA for any help.

Members,

I am trying to run Automatic mail from my word! But I am getting the error 'Compile Error: User-defined type not defined' Attempting to Compile Code

As well as I am also getting the error of Can't execute code in break mode!

Any idea How to solve this issue?

The Entire VBA code are below;

Anyone can help me?