Connect with us

MS Word

How to Format Text and Numbers in Mail Merge Data in Microsoft Word

Published

on

How to Format Text and Numbers in Mail Merge Data in Microsoft Word

As usual, We want to share tutorials on the most fun topics for all of you, Good guys! This time there is a review on how to format mail merge data in Microsoft Word.

Have you heard of this tutorial yet? If not, let’s just read the following article to the end.

HOW TO CREATE A MAIL MERGE DATA FORMAT IN WORD

How to create a mail merge data format in Microsoft Word referred to here, such as font formatting, making upper and lower case letters, and creating formats for dates, currencies, and numbers.

Let’s discuss it one by one!

Formatting Text in Mail Merge Data

The first tutorial is how to format the text in mail merge data, whether from Excel or other sources. These data are called data fields.

Next, if you want to bold the data or change the font size and type, the format is as follows:

  • Select the fields you want to format in a mail merge document in Microsoft Word, including the double square brackets (« »).
  • On the Home tab, in the Font group, select the desired format.
  • For this method, you can give the format that is in the Font in this Word mail merge data, including:
  1. Change the font size and type.
  2. Bold (CTRL + B), italic (CTRL + I), and underline (CTRL + U).
  3. Cross out text.
  4. Giving format subscript (CTRL + =) dan superscript (CTRL + SHIFT + +).
  5. Highlight the text.
  6. Change color.

HOW TO CREATE A MAIL MERGE DATA FORMAT IN WORD

Create Uppercase and Lowercase Letters on Data Mail Merge


There is also a way to change the uppercase (capital) and lowercase letters in the mail merge data in Word. But before that, you need to add a unique ‘formatting switch’ code, as described below:

  • In the MS. Word mail merge document, press the shortcut key ALT + F9 to display the field code. Example field code: { MERGEFIELD Name }.
  • Next to the field name, press the space bar and type one of the following codes:

  1. * Caps – to capitalize the first letter of each text. Example: Lorem Ipsum Sit Amet.
  2. * FirstCap – to capitalize the first letter in the text. Example: Lorem ipsum dolor sit amet.
  3. * Upper – to capitalize all letters. Example: LOREM IPSUM DOLOR SIT AMET.
  4. * Lower – to make all letters lowercase. Example: lorem ipsum dolor sit amet.
  • Next, press the shortcut key ALT + F9 again on the keyboard to hide the field code.


Creating Number, Currency, and Date Formats in Mail Merge


Next is a tutorial on displaying or generating number formats, currency symbols, percentage symbols, and dates in Microsoft Word mail merge.

The steps are as follows:

  • In a Microsoft Word mail merge document, press the shortcut key ALT + F9 to display the field code.
  • Press the ALT + F9 keys again to hide the field code.
  • Next, next to the field name, press the space bar and type as follows:
  1. Thousands Separator – Add a switch (in bold) to the code field. Example: { MERGEFIELD Number # #.### }
  2. Decimal Separator – Add a switch to the code field. Example: { MERGEFIELD Number # #.###,00 }
  3. Stair Format – Add a switch to the code field. Example: { MERGEFIELD Date \@ ” dd MMMM yyyy” } or { MERGEFIELD Date \@ ” dd-MM-yyyy” }


So, that was the tutorial on how to format the mail merge data in Microsoft Word, whether it’s text formatting, uppercase, and lowercase letters, as well as number and symbol formats.

MS Word

How to Make Letterhead in Microsoft Word

Published

on

How to Make Letterhead in Microsoft Word

How to make a letterhead in Word correctly and neatly is actually easy, but surely there are still many of you who don’t know how to make it.

In an official letter, of course, there is a letterhead and there is always a line at the bottom right. Well, it turned out to be quite easy to make you know.

Apart from being the introduction to a letter, letterhead is also commonly used as a place to write the identity of the letter, such as the identity of the sender and recipient.

For those of you who want to know how to make it, here we explain in full the steps to make a letterhead in Word for you.

HOW TO MAKE LETTERHEAD IN WORD

You should know how to make a letterhead in Word this time, guys, especially when you want to send letters between agencies.

Although not all agencies use it, it doesn’t hurt you to try and find out how to make this letterhead, here are the steps!

  • First, open your Word.
  • Place the cursor at the back of the last word of the letterhead
  • Then select the menu Borders – Borders and Shading.
  • After the border menu appears, all you have to do is select the line you want on the menu with a sign like this.

Don’t rush to click Ok, because there’s one more thing you have to do to make it, guys. In the section below, remove it or set it like this to make the line only exist at the bottom, and then Ok.

Yeah, you have successfully drawn the line, Guys, it’s easy and fast, right, how to make a letterhead in Word?

You don’t need to be confused anymore about how to make it. For beginners, making letterhead or letterhead does sound quite difficult.

In fact, how to make a letterhead in Word is fairly easy as long as you already know the procedure. After all, the letterhead cannot be made casually because it is an official identity.

The letterhead contains the official identity of an institution, agency, or company. Well, you can create an official identity on the letterhead in Microsoft Word.

Continue Reading

MS Word

How to Create a Background in Microsoft Word

Published

on

How to Create a Background in Microsoft Word

This way of making a background in Word aims to beautify the appearance of the document and make it more attractive Guys.

Usually, this is often found in the use of proposals, certificates, covers, and not infrequently in job applications.

With this function, how do you make it? It’s so easy. Yes, although there are several ways you can do this, you can follow this tutorial in full.

HOW TO MAKE A BACKGROUND IN WORD

This background function is very useful if you want to create a document that upholds the originality of Guys, for example, a thesis.

In addition to having to know how to create a table of contents in Microsoft Word, you may also need to know how to create a background in your thesis document, especially in showing the results of the tests you did.

How to make this background is also needed if you want to make an official letter from the agency. Besides needing to know how to make letterhead lines in Word, you also need to know how to add a background to the letter. Here’s how:

  • The first thing you can do is change the color.
  • Go to Design – Page Color – and immediately choose a color like this.

That is the easiest way and you can change the color according to your needs or tastes, guys. In addition to this method, you can also replace it with an image that you have.

The method is almost the same, guys, pay attention to the following rare:

  • Go to the Design menu.
  • Click Page Color.
  • Select Fill Effects.
  • Next, select the tab Picture – Select Picture – From a File.
  • Then find the image you have and press Ok
  • Finished! The background will change.

But, you also need to remember that both methods will not appear when you print either color or image.

To make it appear when printing, then you need to go to the File menu – Options – Display – and check the Print background colors and Image.

Well, after you go through these few steps, the background will change and also enter when you print, GRATZ!!! It’s easy to make a background in Word.

Continue Reading

MS Word

How to Create a Signature in Word

Published

on

How to Create a Signature in Word

There are several ways to make a signature in Microsoft Word. And the method is really easy, just follow the steps below, guys!

Making a signature is really needed, especially in the digital era like now, right? Of course, you need a signature in your Word file, so from that our Team will provide this tutorial in detail.

Actually, you can also use a third application or additional devices such as pens that support your PC or laptop. But this is the easiest way without using other devices and applications Guys.

HOW TO CREATE A SIGNATURE IN WORD

You need to sign first, Guys on a piece of white paper. Make sure the paper is really white and the pen has colour ink that you can really see clearly.

This function is for later photos or files the resolution will be smaller Guys. Not only that, but the customized color saturation will also reduce the thickness of the pen color, you know.

So make sure you give a signature with a clear enough emphasis. Here’s how to create a signature in Word:

  • Prepare a white paper with a signature on it. Photos using a smartphone or you can directly scan the signature through a scanner.
Create a Signature in ms Word
  • You can reduce the resolution and crop it so that the photo focuses on the signature. For convenience, click the image file > Edit.
  • On the Paint menu, you can resize to reduce the resolution. Choose 50 per cent resolution, fill Horizontal 50 and Vertical 50
How to Create Signature in Word
  • Hover over the exact position of the word you want to add a signature to. Click Insert > Picture > insert the previous signature image file.
Create a Signature in Word
  • After you insert the image, reduce the size again using the cursor for more precision.
  • Double click on the image.
  • On the Format menu, select the Color > Recolor > Black and White 50 per cent submenu.
How to Create a Signature in ms Word
  • if your signature is not clear, double click on the image, select menu Correction > Brightness 0 per cent (Normal) Contrast 40 per cent.

You can change the last two steps depending on the contrast and color saturation you want, guys. So you can at the same time adjust the thickness of your signature that has entered the word, so guys.

I also said what Guys, how easy it is to make a signature in Microsoft Word! The most important thing is to make sure your signature is clear enough, and the photos are of high enough quality. Obviously, so that later your signature looks good, it doesn’t break.

Continue Reading
Advertisement

Latest

Fix File Sharing Not Working in MacOS Ventura Fix File Sharing Not Working in MacOS Ventura
Mac14 hours ago

Fix File Sharing Not Working in MacOS Ventura

SHARE More File sharing is a vital feature in macOS Ventura, as it allows multiple users to access and share...

How To Search Tabs in Google Chrome How To Search Tabs in Google Chrome
Internet1 day ago

How To Search Tabs in Google Chrome

SHARE More Google Chrome is one of the most popular web browsers used by millions of people around the world....

How To Format USB Drive on Mac How To Format USB Drive on Mac
Mac1 day ago

How To Format USB Drive on Mac

SHARE More Formatting a USB drive on a Mac is a simple process that can help you get the most...

How to Disable Missed Call Return from iPhone Lock Screen How to Disable Missed Call Return from iPhone Lock Screen
iPhone2 days ago

How to Disable Missed Call Return from iPhone Lock Screen

SHARE More As an iPhone user, you may have noticed that when you miss a call, a banner notification pops...

What is Apple ID Used For What is Apple ID Used For
iPhone2 days ago

What is Apple ID Used For

SHARE More An Apple ID is a unique account that allows users to access various Apple services and products, such...

What is Type-C USB What is Type-C USB
Wiki3 days ago

What is Type-C USB

SHARE More Type C USB, also known as USB-C, is a new standard in USB technology that offers faster data...

How To Find Your Apple ID - With 7 Ways How To Find Your Apple ID - With 7 Ways
iPhone3 days ago

How To Find Your Apple ID – With 7 Ways

SHARE More Apple ID is a unique identification that is required to access various Apple services such as iCloud, iTunes,...

What is an External Hard Drive What is an External Hard Drive
Wiki3 days ago

What is an External Hard Drive

SHARE More An external hard drive is a type of storage device that can be used to store and back...

What is Apple ID What is Apple ID
iPhone4 days ago

What is Apple ID

SHARE More An Apple ID is a unique account that is used to access various services provided by Apple, such...

What is 5G What is 5G
Internet5 days ago

5G: Everything You Need To Know | What is 5G

SHARE More 5G, or fifth-generation cellular technology, is the latest and greatest in mobile network technology. With faster speeds, lower...

Categories

Trending

Share via
Copy link
Powered by Social Snap