Out Of Office Newsletter - For Professionals working with text

For professionals working with text

Home Out of Office Newsletter Macros and useful tools Éditorial 001 Editorial 001 Editorial 001
The Team

Welcome to the October issue of OUT OF OFFICE. This month we will look at the basics of Outlook®.

Any business needs to properly manage its communications - and communications must not be allowed to hamper the workflow. To that end, a certain set of good practices exists to ensure that you are not constantly distracted, and we will review some of those in the first part of this newsletter.

In the second part, we will create a macro that will check your attachments and do a few more things before sending your professional e-mails. As this macro is quite complex and has been created for you so that you can see and understand the various aspects of creating macros, it will be spread over three issues. In Issue 000, you learned the basic of forming sentences in VBA. In this issue and the next two, we will expand and you will be learning how to write a complete story including a dialogue by:

  • creating basic user forms,
  • writing functions,
  • using other applications from one application,
  • and a few more nifty things.

The aim of the VBA part is not to turn you into a programmer, but to help you understand how to get the machine to do what you need and to gain a better grasp of how software works, while also providing you with an additional useful tool for your work.

As usual, if you would like to see a specific issue explained in this newsletter, please do not hesitate to send an email to outofoffice.newsletter@gmail.com with "How do I...? in the subject line, with a detailed explanation of what you would like to achieve and if possible some sample files.

Enjoy this issue!

The OUT OF OFFICE team

Content

In this issue: In the next issue:

Outlook Looks Good

Always Excel

Managing Junk Defining cell content
Adding a contact Referencing
Creating rules Formulas specific to text
Editing rules

VBA for Ever

VBA for Ever

List of attachment (Part 1 of 3) List of attachment (Part 2 of 3)

Subscribe
Issue 000
Editorial 001
002
003
IAPTI
NWTN


Professional memberships:


CIoL
Ptc
Proz.com
Copyright. Hacène Dramchini 2015. All rights reserved.