Outlook has no native feature to set the default font for the body of contact, appointment and task item. Thus, if you want to specify the font, you can resort to the method introduced in this article.

Like the email, Outlook appointment, task and contact also have the body field, in which we can fill in the item details. However, Outlook only permits users to set the default font used in the email body. If you would like to specify the font in the body of contact, appointment or task, you have to seek other means, such as third party add-ins or Outlook VBA. Here we will elaborately teach you how to use VBA to get it. Read on to learn the detailed steps and corresponding VBA codes.

Set the Default Font for the Body of Contact Appointment and Task

Set the Default Font for the Body of Appointment, Task and Contact

  1. At the very outset, start your Outlook program.
  2. Then press “Alt + F11” key buttons to launch Outlook VBA editor.
  3. In the popup window, you need to open the “ThisOutlookSession” project.
  4. Subsequently, copy the following VBA codes into this project window.
Public WithEvents objInspectors As Outlook.Inspectors
Public WithEvents objInspector As Outlook.Inspector

Public Sub Application_Startup()
    Set objInspectors = Outlook.Application.Inspectors
End Sub

Public Sub objInspectors_NewInspector(ByVal Inspector As Outlook.Inspector)
    Set objInspector = Inspector
End Sub

Public Sub objInspector_Activate()
    Dim objCurrentItem As Object
    Dim objCurrentInspector As Outlook.Inspector
    Dim objWordDocument As Word.Document
    Dim objWordSelection As Word.Selection
 
    Set objCurrentItem = objInspector.CurrentItem
    Set objCurrentInspector = objCurrentItem.GetInspector
    Set objWordDocument = objCurrentInspector.WordEditor
    Set objWordSelection = objWordDocument.Application.Selection
 
    'You change the font as per your preference
    Select Case objCurrentItem.Class
           Case olContact
                With objWordSelection.Font
                     .Name = "Segoe Script"
                     .ColorIndex = wdRed
                     .Size = 8
                     .Bold = True
                End With
           Case olAppointment
                With objWordSelection.Font
                     .Name = "Comic Sans MS"
                     .ColorIndex = wdBlue
                     .Size = 9
                     .Bold = False
                End With
           Case olTask
                With objWordSelection.Font
                     .Name = "MV Boli"
                     .ColorIndex = wdGreen
                     .Size = 10
                     .Bold = True
                End With
   End Select
End Sub

VBA Codes- Set the Default Font for the Body of Contact, Appointment and Task

  1. After that, you need to sign this code.
  • First, create a digital certificate by Digital Certificates for VBA Projects.
  • Then assign this certificate to the new macro.
  1. Later, you could change your Outlook macro settings to permit the digitally signed macros.
  2. Finally you start your Outlook to activate the new VBA project. From now on, when you create a new contact, appointment or task, body will use its default font, like the following screenshot:Default Font for the Body of Contact, Appointment and Task

Protect Your PST Data against Corruption

Due to the fact that Outlook PST file is prone to error and corruption, you have to pay much attention to PST protections. For instance, you should beware of emails from unknown sources in that they may be malicious emails with viruses. Once your PST file gets infected, you have to recur to a reputable and well-proven fix tool, such as DataNumen Outlook Repair, which can repair PST file like a breeze.

Author Introduction:

Shirley Zhang is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including fix SQL Server and outlook repair software products. For more information visit www.datanumen.com

Be the first to comment
             

In today’s article, we are excited to explain 2 ways to you to change the caption style in your Word document.

What is a Caption?

A caption is kind of label, consisting of text and number. You can use it to number all tables or pictures in your Word document so as to maintain them in a sequence order, such as bellow:Captions

Generally, you can right click on a table or a picture and choose “Insert Caption”. Then select proper caption label to insert a caption.Choose "Insert Caption"

As you may notice, the caption inserted into your document appears in blue by default. This can cause inconsistency with the document formatting. Therefore, here is the demand to alter the caption style as required. Bellowing are 2 methods that enable you to do so.

Method 1: Create a Template

  1. To begin with, click “Home” tab.
  2. Then click “Styles” button to open the same name window.Click "Home"->Click "Styles" Button
  3. Next click “Options” at the bottom of the window to trigger the “Style Pane Options” box.
  4. Choose “All styles” to show and click “OK”.
  5. Now all styles shall show on the “Styles” window. Find “Caption” and hover the cursor on it until you see an upside-down triangle button.
  6. Click on the button to bring out the menu.Click button->Choose "Modify" or "Select All XX Instances"
  7. If you just need to change the caption style for one-time use, click “Select All XX Instances”. Then all captions shall in selection. You can apply whatever styles you like for them.
  8. If you want to create a template for later use, click “Modify”.
  9. In “Modify Style” box, set the formatting like font and color. Click “OK” after finishing this.Set Formatting->Click "OK"
  10. Next click “File” and then “Save As”.
  11. In “Save As” window, choose “Word Template” as saving type and click “Save”.Choose "Word Template" as saving type->Click "Save"

Method 2: Use Word Macro

In case you don’t want to create extra template, macro is the remedy you need.

  1. First and foremost, press “Alt+ F11” to open VBA editor.
  2. Next go to “Normal” project and click it.
  3. Then click “Insert” tab and choose “Module”.Click "Normal"->Click "Insert"->Click "Module"
  4. Double click on the new module to bring out the editing area on the right side.
  5. Paste the following macro there:
Sub SetCaptionStyle()
  Dim objDoc As Document
 
  Set objDoc = ActiveDocument
 
  objDoc.FormattingShowFilter = wdShowFilterFormattingInUse
  objDoc.StyleSortMethod = wdStyleSortByName
  With objDoc.Styles("Caption").Font
    .Name = "Times New Roman"
    .Size = 14
    .Bold = True
    .Italic = False
    .Underline = wdUnderlineNone
    .ColorIndex = wdBrightGreen
    .Engrave = False
    .Superscript = False
    .Subscript = False
    .Scaling = 100
    .Kerning = 0
    .Animation = wdAnimationNone
    .Ligatures = wdLigaturesNone
    .NumberSpacing = wdNumberSpacingDefault
    .NumberForm = wdNumberFormDefault
    .StylisticSet = wdStylisticSetDefault
    .ContextualAlternates = 0
  End With
  With objDoc.Styles("Caption")
    .AutomaticallyUpdate = False
    .BaseStyle = "Normal"
    .NextParagraphStyle = "Normal"
  End With
End Sub
  1. Lastly, click “Run”.Paste macro->Click "Run"Effect of changing caption style

Notes:

  1. In code line “.Name = “Times New Roman”, replace the font name with the one you actually need.
  2. In code line “.ColorIndex = wdBrightGreen”, you can change the color as required. For more color choices, you can refer to this link: https://msdn.microsoft.com/en-us/library/office/aa195611(v=office.11).aspx

Careful with Document Corruption

As you see, there is always more than one way to solve a problem in Word. Most of the time, we can have problems fixed. Yet, at other times, unexpected thing can happen. For example, because of operation errors, Word can collapse and result in doc damage. Thus, one has to be extremely careful with actions they don’t familiar with to avoid the unlucky.

Author Introduction:

Vera Chen is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including xlsx corruption and pdf repair software products. For more information visit www.datanumen.com

Be the first to comment
             

In this article, we look at the process setting up an Always On Availability Group in SQL Server Standard Edition in a stepwise manner.

SQL Server Standard EditionWith the coming of AlwaysOn Availability Groups in the Standard Edition of SQL Server 2016, the deprecated feature of Database Mirroring will be replaced. The Standard Edition of 2016 supports Basic Availability Groups, which is another name for the AlwaysOn Availability groups in the Enterprise edition. Although setting up Basic Availability Groups is very similar to setting up AlwaysOn Availability Group in the enterprise edition, there are slight differences between the two. The Basic availability group seems to be having more limitations as compared to AlwaysOn, it allows for only two nodes (primary and secondary), it requires all databases to have their own Availability Groups, etc.

Basic Availability Group (BAG) might be having a few limitations, but setting it up is quite similar to setting up AlwaysOn, here are the steps for setting up a BAG.

  1. Set Up An Always On Availability Group In SQL Server 2016 Standard Edition

    Enable Windows Clustering – This is like a prerequisite for enabling BAG for all instances of SQL Server. You will first have to initiate a Windows Failover cluster and then enable AlwaysOn for all instances. This is important because the Availability Groups (AGs) feature in SQL Server is built over Windows Failover Cluster.

  1. Validate Candidates in the Cluster – Go to Server Manager, click on Tools > Failover Cluster Manager. Select Validate Configuration, to begin the Wizard, after selecting names of servers, you want to be a part of the Availability Group, click Next. Validation might take long, depending on the complexity of the environments, amount of replicas, etc.
  1. Failover Cluster Validation Report – This report might end up showing that your cluster failed, it is Ok, do not worry. You can click on View Report, to view the full report, click on the first error, and you will see details along with a possible solution. Read the problems carefully, and solve all issues before you proceed.

*Once you have fixed the issues, you are advised to rerun the Validation Wizard, so that your Failover Cluster Report is always looking good, because that is what Microsoft will look at, if you ever ask for help with AGs.

  1. Creating A Cluster – When you receive your Cluster Failover Report, check the ‘Create Cluster Now’ check box, and click on Finish. Your Cluster is now ready, add a cluster name again, and click on Next.
  1. Configure Cluster Quorum Settings – Once your cluster is ready, you will have to add a witness, Right click on cluster name then go to More Actions and choose the Configure Cluster Quorum Settings. In the appearing window, go to ‘Select Quorum Witnesses’, choose a disk or file share witness. Click on ‘OK’ to exit the wizard.
  1. Setting up BAG – Launch SQL configuration for all replicas, go to SQL Server Services, right click on SQL Server, and select properties, for all SQL instances.
  1. Creating AGs – From the New Availability Group Window, select ‘BAG’. You will now have to specify replicas, which will then be followed by your Synchronization Preferences. This will end the AG Wizard. You can see the complete window, with all details in the SQL Server Management Studio

While setting up a BAG will go a long way in maintaining business continuity, procuring a mdf repair tool would go a long way in completely avoiding any data loss due to a SQL Crash.

Author Introduction:

Victor Simon is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including access fix and sql recovery software products. For more information visit www.datanumen.com

Be the first to comment