/VBAMacros

My commonly used VBA macros

Primary LanguageVBA

Word & Excel VBAMacros

emailundeliverable.txt: VLookup Macro. Updates an excel spreadsheet with "Undeliverable" for all undeliverable emails and "Email Sent" confirmation otherwise. Skips over cells with entries.

findreplace.txt: Find and replace macro to quickly edit docx templates and make replacements. On templated docx files with established text formatting, activating the findreplace macro will bring up a user box asking for the replacement text. Once the replacement text is submitted, the macro will go through and replace all template placeholders matching the established text formatting with the entered text.

mailmerge.txt: Quickly move through mail merge steps in Word.

statictext.txt: Copy cells and paste values to remove formulas.