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

Who Invented Lithium ion Battery Who Invented Lithium ion Battery
Wiki3 days ago

Who Invented Lithium ion Batteries

SHARE More Imagine a world without smartphones, laptops, or electric cars. Crazy, right? These amazing devices rely on a powerful...

Who Invented SSD Who Invented SSD
Wiki2 weeks ago

Who Invented SSD : A Journey From Invention To Innovation

SHARE More The dominance of Solid State Drives (SSDs) in modern data storage is undeniable. Their lightning-fast performance, superior reliability,...

Google Gemini Google Gemini
Wiki3 weeks ago

Google Gemini: Your Super-Smart AI Sidekick (Made Easy!)

SHARE More Imagine a helpful friend who can write emails, translate languages, dream up creative ideas, and even write code!...

Who Invented Gorilla Glass Who Invented Gorilla Glass
Wiki4 weeks ago

Who Invented Gorilla Glass for Mobile: Unveiling the Inventor and Its Impact

SHARE More In the ever-evolving landscape of mobile technology, Gorilla Glass has emerged as a revolutionary material, providing durability and...

The Evolution of Touch Screen Technology A Journey into its Inventors and Innovations The Evolution of Touch Screen Technology A Journey into its Inventors and Innovations
Wiki1 month ago

The Evolution of Touch Screen Technology: A Journey into its Inventors and Innovations

SHARE More Touch screen technology has become an integral part of our daily lives, seamlessly blending with our smartphones, tablets,...

The Evolution of Memory Cards: Unraveling the Inventors Behind the Innovation The Evolution of Memory Cards: Unraveling the Inventors Behind the Innovation
Wiki1 month ago

The Evolution of Memory Cards: Unraveling the Inventors Behind the Innovation

SHARE More In the fast-paced world of technology, memory cards have become an indispensable part of our daily lives. From...

Who Invented Sim Card Who Invented Sim Card
Wiki2 months ago

Who Invented Sim Card | The Origin and Inventor of the SIM Card: A Revolutionary Communication Breakthrough

SHARE More In today’s digitally interconnected world, the SIM card stands as a tiny yet indispensable component of our daily...

Walkie-Talkies Walkie-Talkies
Wiki3 months ago

Who invented Walkie-Talkie | Exploring the Wonders of Walkie-Talkies: A Simple Guide for Beginners

SHARE More Walkie-talkies, often fondly referred to as “woki tokies,” are incredible communication devices that have stood the test of...

Who Invented Camera Lens Who Invented Camera Lens
Wiki3 months ago

Who Invented Camera Lens : A Revolutionary Innovation in Photography

SHARE More The invention of the camera lens stands as a pivotal milestone in the history of photography, fundamentally altering...

Who Invented Radio Who Invented Radio
Wiki4 months ago

The Evolution of Radio Broadcasting: Who Invented Radio?

SHARE More Radio broadcasting has been a cornerstone of communication, entertainment, and information dissemination for over a century. It revolutionized...

Trending

Share via
Copy link
Powered by Social Snap