Inside Microsoft Office

Switch newsletter nameplate colors automatically with a simple macro

Inside Microsoft Office

by Julie Duncan

Placing new articles and graphics in each edition of your newsletter is enough of a challenge-why waste time updating the newsletter nameplate manually? Instead, use our straightforward macro. It will buy you extra time that you can spend perfecting the content of your newsletter or planning for the next edition.

Create the nameplate

First, we need a simple nameplate for the newsletter to work with. You can download the file from the URL[…]


Subscribe to Inside Microsoft Office

(get full access to archives and more)