helpcharity
New Member
- Joined
- Apr 25, 2019
- Messages
- 8
- Office Version
- 2019
- Platform
- Windows
Hi,
I work for a charity near Liverpool (UK) and need some help please.
When we send our template introduction letter to our beneficiaries we have to include a selection of 5-10 (out of around 50) standard paragraphs of text to insert into a letter. Currently we use Word 2016, and set up a document with 50 "building blocks", but we're finding that a very inefficient process.
None of us are VBA literate, but so far we've worked out how to create a macro which;
a) opens a "new" word document, and
b) copies the content of a single cell into the blank document
But ideally, we would like some help to create a macro which;
a) copies the contents of the selected cells in the excel worksheet
b) opens our template letter (in Word 2016)
c) pastes the contents of the cells into the letter at specific sections (e.g. at bookmark points)... Ideally we would also like to copy the formatting and colour of the text in the cells... instead of it just being copied as black text.
d) renames and saves the amended template letter (i.e. before the template letter is overwritten).
Hope all this makes sense.... and hope someone can help.
I work for a charity near Liverpool (UK) and need some help please.
When we send our template introduction letter to our beneficiaries we have to include a selection of 5-10 (out of around 50) standard paragraphs of text to insert into a letter. Currently we use Word 2016, and set up a document with 50 "building blocks", but we're finding that a very inefficient process.
None of us are VBA literate, but so far we've worked out how to create a macro which;
a) opens a "new" word document, and
b) copies the content of a single cell into the blank document
But ideally, we would like some help to create a macro which;
a) copies the contents of the selected cells in the excel worksheet
b) opens our template letter (in Word 2016)
c) pastes the contents of the cells into the letter at specific sections (e.g. at bookmark points)... Ideally we would also like to copy the formatting and colour of the text in the cells... instead of it just being copied as black text.
d) renames and saves the amended template letter (i.e. before the template letter is overwritten).
Hope all this makes sense.... and hope someone can help.
