Hi everyone;
I apologize in advance if this question has already been answered somewhere in the forums - I did a few searches but had no luck finding what I was looking for. I'm new to coding in VBA, and am looking to find a way to create a letter in Microsoft Word with a standard paragraph at the beginning and another at the end, but with the paragraphs in the middle pulled from an excel spreadsheet based on selections made in a userform within word.
----------------------
The letter would look something like this:
Name
Address
Dear Sir/Madam;
Beginning Paragraph: This paragraph will appear at the beginning of every letter.
Middle paragraphs will be generated here based on answers to questions on the userform:
RE101 (if checked on userform)
RE102 (if checked on userform)
RE103 (if checked on userform)
Ending Paragraph: This ending paragraph will appear at the end of every letter.
Sincerely,
TMAL
----------------------
The userform will ideally be just a simple series of checkboxes:
RE101: □ Add to letter
RE102: □ Add to letter
RE103: □ Add to letter
----------------------
The excel spreadsheet will be set up something like this:
In Column A: Labels for the associated paragraph (RE101, RE102, RE103, etc)
In Column B: Paragraphs of text to be inserted into the document (Text for RE101, Text for RE102, Text for RE103, etc)
----------------------
Any help you can provide will be much appreciated - I'm quite new to VBA and don't really know where to start.
Thanks!!
TMAL