I've been asked to look at creating a tool which will allow users to input information which is to be shown in a newsletter.

I already have a termplate for the newsletter.

Does anyone know of any examples online of something like this?

Alternatively, my idea, is to have an excel sheet with:

Dropdowns for the section heading of the newsletter, i.e. Best Practice, Important information/updates, diversity, l9ocal information, etc
large boxes for text (the content of the newsletter)

Then at the bottom a button press which will paste the information into the newsletter template and add a fancy border around each area of text.

I know I can add the text based on bookmarks etc, but is there a macro which will allow me to select the 'next available bokmark, just as you can select the next available line/last line in an excel document?

I personally don't understand why the tool is wanted given they have a template, but it is and I've been volunteered to look into it.

Any help would be much appreciated.