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 Save and Maximize RAM Capacity on Android Phones How to Save and Maximize RAM Capacity on Android Phones
How-To15 hours ago

How to Save and Maximize RAM Capacity on Android Phones

SHARE More RAM on an android phone is used to store temporary data on your android while doing any activity...

Cool Stylish Text generator Tools List Cool Stylish Text generator Tools List
Social Media1 week ago

Cool Stylish Text generator Tools List

SHARE More Are you looking for the Best Fancy Fonts generators if yes then We have found some awesome websites...

Tips and Ways to Make Android Storage Not Full Tips and Ways to Make Android Storage Not Full
Android2 weeks ago

Tips and Ways to Make Android Storage Not Full

SHARE More There are quite a number of applications and games on Android phones that have a large enough capacity,...

USB 4.0 New Generation of USB With Ultra-Fast Data Transfer Speed USB 4.0 New Generation of USB With Ultra-Fast Data Transfer Speed
News3 weeks ago

USB 4.0 New Generation of USB With Ultra-Fast Data Transfer Speed

SHARE More Currently, USB is still the standard for transferring cable-based data, in this latest generation, version 4.0, there is...

How to Restore Deleted Telegram Chats How to Restore Deleted Telegram Chats
Social Media4 weeks ago

How to Restore Deleted Telegram Chats

SHARE More Is it possible to restore chats, photos, and other files in the Telegram app? If you accidentally or...

How to Find Hidden Apps on Android Phone How to Find Hidden Apps on Android Phone
Android1 month ago

How to Find Hidden Apps on Android Phone

SHARE More Lately, there are quite a few cases of tracking using hidden applications on Android phones; in addition to...

How to Fix Broken SD CardMicro SD on Android Without Using a PCLaptop How to Fix Broken SD CardMicro SD on Android Without Using a PCLaptop
Life Hack1 month ago

How to Fix Broken SD Card/Micro SD on Android Without Using a PC/Laptop

SHARE More SD Card or Micro SD is one way to increase storage capacity on Android phones, but there are...

How to Hide Notifications When Lock Screen on Android Phone How to Hide Notifications When Lock Screen on Android Phone
Android2 months ago

How to Hide Notifications When Lock Screen on Android Phone

SHARE More In the default settings, a notification on an android phone is set so that it allows us to...

How to Overcome Camera Can't Focus on Android How to Overcome Camera Can't Focus on Android
Android2 months ago

How to Overcome Camera Can’t Focus on Android

SHARE More When the camera focus feature doesn’t work correctly or doesn’t work at all on an Android phone, one...

How to Convert JPEG Format to Excel How to Convert JPEG Format to Excel
How-To2 months ago

How to Convert JPEG Format to Excel

SHARE More Do you want to convert a JPEG file to Excel? The answer is Yes. As we know, a...

Categories

Trending

Share via
Copy link
Powered by Social Snap