For any Microsoft Office user familiar with Word, Excel, PowerPoint, Access, or Outlook, this book provides tutorials on the tools and tricks that automate these programs for increased productivity. Each lesson includes instructions and a downloadable file on which to test the VBA macros and procedures provided. Tasks covered include how to run several mail merges at once, removing duplicates from data, and saving email attachments.
I am really good at Excel VBA, but I am lost if I have to automate Word, Outlook, or PowerPoint. This book includes 25 examples from each Office program. I can look at the examples written by the Word expert or the PowerPoint expert and figure out how to take my current knowledge about Excel VBA and translate it to Word or PowerPoint VBA.