Connect with us

MS Word

How to Make Mail Merge Images in Microsoft Word 2007 and 2010

Published

on

How to Make Mail Merge Images in Microsoft Word 2007 and 2010

Often use Microsoft Word, must have known about mail merge. What is mail merge?

Launching from Google Sites, the notion of mail merge is a tool that allows users to easily create several types of letters, labels, envelopes, name tags, and more.

With Mail Merge, you will be helped to create a letter with the same content for different recipients in no time, including image mail merge.

Then, how to make Mail Merge images? It’s easy. But first, you’ll need a Word document (either an existing one or a new one) as well as a list of recipients for the Mail Merge image.

HOW TO MAIL MERGE IMAGES IN MS WORD

Make Mail Merge Images in Microsoft Word

In this article, we will explain a tutorial on how to create a mail merge image with data sources from Microsoft Word.

Because in addition to letters, Mail Merge can be used to create catalogs, photo exam cards, signed letters, and so on.

Here are the steps to create an image mail merge in Word that you can follow step by step:

  1. First, you need to create a Microsoft Excel data source and a master document in Microsoft Word. The method:
  • Prepare the image file for the catalog and save it in the same folder as the mail merge document.
  • Then, create a data source in Microsoft Excel 2007 or 2010 and save it in Excel 97 – 2003 (.xls) format with a menu name. Make sure the Image Name matches the image file name.
  • Then, open a new Ms Word 2007 or 2010 document. Create a master document in the form of a table and save it in Ms Word 97 – 2003 (.doc) format.

Notes:

The reason why Word and Excel documents must be saved in 97-2003 format is that the IncludePicture feature that will be used in image mail merge cannot be used in Word 2007 and 2010 (there is a bug).

  1. Second, you need to combine the data source with the master document. The method:
  • In the Ms Word master document, select the Mailings menu >> Start Mail Merge >> Start Mail Merge >> Directory.
  • Then, insert the data source by opening the ‘Mailings’ menu, then selecting ‘Start Mail Merge’ and clicking ‘Select Recipients’.
  • Select Use Existing List. Then locate the document (menu.xls) in the Select Data Source dialog box and click Open.
  • Enter data in each place. The trick, put the cursor next to the words Code.
  • Then on the Mailings tab, select Write & Insert Fields and click Insert Merge Field and then select Code.
  • Do the same with Snack.
  • Next insert the image. Click on the second column of the table.
  • On the Insert tab, select Illustrations, then click Picture and locate the image.
  • Click one of the catalog images. Then, click the arrow on the Insert button and select Link to File.
  • Enlarge the image size by: select the Picture Tools menu >> Format >> Size. Then set the Height or Width values ​​to set the width and height of the image.
  • Press the ALT + F9 keys to display the field code.
  • Delete the image filename.
  • Make sure the cursor position is still in the position of the image file name (bread) that has been deleted.
  • Then on the Mailings tab, select Write & Insert Fields.
  • Click Insert Merge Field afterwards and select Image_Name.
  • Next, you need to add one more code so that the images match their respective data.
  • Make sure the cursor position is still in the position of the image file name that has been deleted.
  • Then on the Mailings menu tab, select Write & Insert Fields, click Insert Merge Field and select Image_Name.
  • You need to add one more code so that the images match the respective data.
  • Select the text {MERGE FIELD Image_Name}.jpg and press CTRL + F9 keys to create curly braces.
  • At the position after the opening curly brace, type IF TRUE.
  • Press the ALT + F9 keys to hide the field code.
  • Click the Mailings tab menu button, click Preview Results. Then click the arrow to move between data/records.
  • If there is still something you want to change, click the Preview Results button again and make changes as desired.
  • To save the Microsoft Word mail merge that has been created, click the Finish & Merge button and select Edit Individual Documents.
  • If there are no more changes, just click All and OK.

Well, that was the tutorial on how to create a mail merge in Microsoft Word, which in this article focuses more on discussing how to create an image mail merge whose data comes from Word. Hopefully useful, yes.

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

How to Show Missing Battery Icon in Windows 10 How to Show Missing Battery Icon in Windows 10
Windows 105 hours ago

How to Show Missing Battery Icon in Windows 10

SHARE How to bring up the missing battery icon in Windows 10 you can do easily, you know. Calm down...

PowerToys 0.51 Released PowerToys 0.51 Released
Microsoft6 hours ago

PowerToys 0.51 Released, Comes With Many Improvements

SHARE Microsoft updated PowerToys to version 0.51, wherein in this version there are a number of new features that have...

How to Measure Distance on Google Maps for PC and Android How to Measure Distance on Google Maps for PC and Android
How-To3 days ago

How to Measure Distance on Google Maps for PC and Android

SHARE How to measure distance on Google Maps can be done with easy and simple steps. What’s the point of...

How to Get Rid of Ad Spam on Google Chrome How to Get Rid of Ad Spam on Google Chrome
Internet3 days ago

How to Get Rid of Ad Spam on Google Chrome

SHARE It is important to know how to remove ad spam on Google Chrome so that internet surfing activities are...

How to Clear Cache on a Xiaomi cellphone How to Clear Cache on a Xiaomi cellphone
How-To1 week ago

How to Clear Cache on a Xiaomi cellphone, so that your cellphone remains responsive!

SHARE How to clear the cache on a Xiaomi cellphone will prevent your cellphone’s performance from decreasing, you know, guys....

How to make an image HD How to make an image HD
Apps1 week ago

How to make an image HD

SHARE How to make an image HD you can do so that the resolution of the image you have is...

How to Recover Lost or Hacked Google Account How to Recover Lost or Hacked Google Account
Life Hack1 week ago

How to Recover Lost or Hacked Google Account

SHARE How to restore a lost or hacked Google account you should try if you are in that situation, Guys....

How to Install New Windows 11 Insider Emoji on Windows 10 How to Install New Windows 11 Insider Emoji on Windows 10
Microsoft1 week ago

New Emoji Now Comes In Windows 11

SHARE Last October, we reported that Emoji in Windows 11 had been updated, at which time only a small number...

Windows 11 Enterprise Virtual Machine Is Available! Windows 11 Enterprise Virtual Machine Is Available!
News1 week ago

Windows 11 Enterprise Virtual Machine Is Available!

SHARE If you are waiting for Windows 11 Enterprise, which contains a number of Enterprise-class features, of course, then the...

Windows 11 Insider Dev Channel Build 22504.1010 Released, Pipeline Testing Only Windows 11 Insider Dev Channel Build 22504.1010 Released, Pipeline Testing Only
News1 week ago

Windows 11 Insider Dev Channel Build 22504.1010 Released, Pipeline Testing Only

SHARE Previously, Microsoft released Windows 11 Insider build 22504 for Windows Insider Dev Channel users, in this build, there are...

Advertisement

Categories

Trending

Copy link
Powered by Social Snap