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