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 change the username in Windows 10 How to change the username in Windows 10
Windows 102 days ago

How to change the username in Windows 10

SHARE More If you want to know how to change your username in Windows 10, This article will show you...

How to Remove Ad Banners in Windows 11 File Explorer How to Remove Ad Banners in Windows 11 File Explorer
Microsoft5 days ago

Microsoft Releases Windows 11 Insider Build 25120 For Insider Dev Channel

SHARE More Last week, Microsoft started releasing Windows 11 Insider Dev Build 25115 (Sun Valley 3) for Insider Dev Channel...

Microsoft Release Windows 11 Insider Build 22581 Microsoft Release Windows 11 Insider Build 22581
Windows 117 days ago

How to Upgrade Windows 11 Home to Windows 11 Pro

SHARE More Generally, nowadays many new devices have received Windows 11 Home by default, even though Windows 11 Home itself...

Here's Leaked One Outlook, Email Client For Windows 11 Here's Leaked One Outlook, Email Client For Windows 11
Microsoft2 weeks ago

Again, Here’s Leaked One Outlook, Email Client For Windows 11

SHARE More As previously reported, Microsoft is developing a new Mail Client that aims to replace all existing Mail Clients,...

Xiaomi 12 Lite 5G - price, specification and what we know before the premiere Xiaomi 12 Lite 5G - price, specification and what we know before the premiere
Phones3 weeks ago

Xiaomi 12 Lite 5G – price, specification and what we know before the premiere

SHARE More Xiaomi 12 Lite 5G is the upcoming medium brand whose premiere is fast approaching. What will the price...

How to avoid closing a business How to avoid closing a business
Business1 month ago

How to avoid closing a business?

SHARE More How to avoid closing a business? The Covid-19 pandemic has wreaked havoc on everyone’s pockets, but especially on...

How to save money How to save money
Finance1 month ago

How to save money: 4 easy steps to get started

SHARE More How to save money: 4 easy steps to get started Undoubtedly, the new year’s arrival is always accompanied...

How to apply for a credit card How to apply for a credit card
Credits1 month ago

How to apply for a credit card?

SHARE More How to apply for a credit card? If you are thinking of applying for a credit card, let...

What is inflation, and how does it affect your business What is inflation, and how does it affect your business
Finance1 month ago

What is inflation, and how does it affect your business?

SHARE More Surely you have heard the term inflation, and it is that it has become relevant in the national...

How to Restore Deleted Photos on PC How to Restore Deleted Photos on PC
Life Hack1 month ago

How to Restore Deleted Photos on PC/Laptop

SHARE More The problem of losing photos is also often experienced by users who store their images on a PC...

Categories

Trending

Share via
Copy link
Powered by Social Snap