Connect with us

Computer

What is Mail Merge in MS word, How to use it(Updated)

Published

on

What is mail Merge in ms word
Spread the love

Mail merge is a useful tool that will allow you to easily produce multiple letters, labels, envelopes, name tags, and more using information stored in a list, database, In Microsoft Word. In this article, I explain what is Mail Merge in MS Word, How to use mail merge step by step.

What is Mail Merge in MS Word?

Mail merge is a feature within most data processing applications that enables users to send a similar letter or document to multiple recipients. Mail Merge is a useful tool that will allow you to easily produce multiple letters, labels, and envelopes, using information stored in a list, or database, In Microsoft Word. This file can be a spreadsheet or database file containing separate fields for each different type of information to be merged within the letter.

How to use mail merge step by step:

  1. Open an existing Word document, or create a new one.
  2. Click the Mailings tab.
  3. Click the Start Mail Merge Command.
  4. Select step by step Mail Merges Wizard.

The MailMerge task pane appears and will guide you through the six main steps to complete a mail merge. The following is an example of how to create a form letter and merge the letter with a recipient list.

mailmerge

Read Also: 20 Interesting Facts About Computer

  • Step 1:
  1. Choose the type of document you wish to create. In this example, Select Letters.
  2. Click Next: Starting document to move to Step 2.

what is Mail Merge

 

  • Step 2:
  1. Select use the current document. Click Next: Select Recipients to move to Step3

mail merge

  • Step 3:

Now you will need an address list so that word can automatically place each address into the document. The list can be in an existing file, such as an Excel Workbook, or you can type a new address list from within the MailMerge Wizard.

1. From the Mail Merge task pane, select Use an existing list and then click Browse.

mailmerge2. Locate your file in the dialog box(you have to navigate to a different folder) and click Open.

how to use mail mage

Read More: What Is Algorithm in Computer

3. If the address list is an AccessDatabase, select the Table that contains the list and click Ok.

What is Mail Merge4. In the Mail Merge Recipients dialog box, you can check or uncheck each recipient to control which ones are used in the mail merge. When you’re DONE, CLICK OK to close the dialog box.

mail

5. From the Mail Merge task pane, click Next: Write your letter to move to step4.

  • Step 4:

To Insert Recipient Data:

1. Place the insertion point in the document where you wish the information to appear.

2. Select Address block, Greeting line, Electronic Postage, or More items from the task pane.

mail

3. Depending on your selection, a dialog box may appear with various options. Select the desired options and click OK.

what is mail merge in ms word

4. A placeholder appears in your document. For Example:”AddressBlock”.

5. Repeat these steps each time you need to enter information from your data record.

6. From the Mail Merge task pane, click Next: Preview tour letters to move to step5.

  • Step 5:

  1. Preview the letters to make sure the information from the recipient list appears correctly in the letter. you can the left and right scroll arrows to view each document.
  2. Click Next: Complete the Merge to move to step6.

Read More: Explain the generation of computers

  • Step 6:

1. Click Print to print the letters.

how to print mail marge

2. The Merge to Printer dialog box opens. Click all, and then click OK.

print

3. The print dialog box will appear. Adjust the print setting if needed, and then click OK.

print mail merge


I hope you get the all information about Mail Merge in MS word and  How to use it. If you like this article, you can share and comment. So that we too have a chance to learn something from your ideas and improve something.

Read Also:

Continue Reading
1 Comment

1 Comment

  1. cbd effects when mixed with thc

    June 11, 2022 at 11:40 am

    Hello everybody , can anyone advise where I can purchase Root Wellness Hemp Flower Cbg Bud Bag?

Leave a Reply

Your email address will not be published.

Computer

Explain How to Write Curve,bend and wrap text in ms word

Published

on

By

How Write Curve text in ms word
Spread the love

Microsoft Word is one the most useful Software for office work, Student presentation, and many more. We use Curve, bend, and wrap text in ms word many times as an office, collage, School presentation Heading. In this article, You will know how to Write Curve, bend, and wrap text in ms word Step by step.

Why do we use Curve, bend, and wrap text in ms word?

Curved text is used when you design a flyer, newsletter, and logo in your Word document to enhance the look of the presentation. Microsoft Word has a very easy way to Write Curve, bend, and wrap text.

How to Write Curve, bend, and wrap text in MS Word Step by step:

Step 1: Open the new or an existing Word document.

Step 2: Highlight or select the text that you want to curve, bend, or warp.

Step 3: Go to the Insert tab on the Ribbon and click on the WordArt icon in the Text section.

Read Also: What is Mail Merge in MS word, How to use it

M S Word Step 1

Step 4: A list of WordArt will appear. Select the letter style from the WordArt list to apply to the text.

WordArt List

Step 5: Once WordArt is added to your text, a new menu Drawing tool is created automatically. Now, go to the Format tab on the Ribbon and click on the drop-down icon then click Text Efforts in the WordArt Styles section.

Text Effect in ms word

Step 6: Click on the Transform option from the Text Effects drop-down menu. Select the curve that you want to apply in the selected text.

How to Write Curve Text in ms word

Result: Now your Selected word is Transformed in your chosen style(Curve, bend, and wrap).

Carve text in Ms Word

 

I hope you get the all information about How to Write Curve, bend, and wrap text in ms word. If you like this article, you can share and comment. So that we too have a chance to learn something from your ideas and improve something.

Read Also:

 

 

Continue Reading

Computer

Explain Lookup function in Excel | Explain V and H lookup Function

Published

on

By

Explain Lookup function in Excel
Spread the love

Lookup is one of the most used full functions in Microsoft Excel. It’s used to categorize under Excel Lookup and reference functions. In this article, I explain What is the Lookup function in Excel | Explain V and H lookup Function

Explain Lookup function in Excel

The LOOKUP Function is categorized under Excel Lookup and reference functions. This section discusses various techniques that you can use to look UP a value in a range of data Excel has three functions(LookUP, V LookUP, H LookUP) designed for this task.

A Look-UP formula essentially returns a value from a table by looking up another related value. A common telephone directory provides a good analogy. If you want to find a person’s telephone number, You first locate the name and then retrieve the corresponding number.

Example of LookUp Function in Excel :

In Worksheet that uses Several look UP formulas. This Worksheet Contains a table of employee data, beginning in row 7. This range name is EmpData. When you enter the last name into cell C2, lookup formulas in D2:G2 retrieve the matching information from the table. If the last name does not appear in column C, the formulas return.

Explain Lookup function in Excel

The following lookup formulas use the Vlookup function:

  • D2 = VLOOKUP (C2, EmpData,2,FALSE)
  • E2 = VLOOKUP (C2, EmpData,3,FALSE)
  • F2 = VLOOKUP (C2, EmpData,4,FALSE)
  • G2 = VLOOKUP (C2, EmpData,5,FALSE)

 

Explain V-Lookup Function in Excel


The VLookup function looks up the value in the first column of the lookup table and returns the corresponding value in a specified table column. So, the lookup table arranges vertically.

The syntax  for the VLookUp Function is: VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)

The VLookup Function’s arguments are as follows:

  • lookup_value: The value is to be in the first column of the lookup table.
  • table_array: The range that contains the lookup table.
  • col_index_num: The column number within the table from which the matching value is in return.
  • range_lookup: Optional. If TRUE or omitted, an approximate match is returned. However, If FALSE, Vlookup will search for an exact match and, if Vlookup can’t find an exact match, the function returns #/NA.

Explain H-Lookup Function in Excel


The HLookup function works just like the VLookup function except that the lookup table is arranged horizontally instead of vertically. The HLookup function looks up the value in the first row of the lookup table and returns the corresponding value in a specified table row.

The syntax  for the HLookUp Function is: HLOOKUP(lookup_value,table_array,row_index_num,range_lookup)

The HLookup function’s arguments are as follows:

  • lookup_value: The value is to be in the first row of the lookup table.
  • table_array: The range that contains the lookup table.
  • row_index_num: The row number within the table from which the matching value is in return.
  • range_lookup: Optional. If TRUE or omitted, an approximate match is returned. However, If FALSE, Vlookup will search for an exact match and, if Vlookup can’t find an exact match, the function returns #/NA.

I hope you get the all information about Explain Lookup function. V and H lookup Function in Excel with Example. If you like this article, you can share and comment. So that we too have a chance to learn something from your ideas and improve something.

Read Also:

 

Continue Reading

Computer

Difference between Vector and Raster graphics?Example

Published

on

By

Difference between Vector and Raster graphics with Example
Spread the love

Graphics help us to see the photo, video, Animation Popularly, and Vector Graphics are sharp and detailed than Raster Graphics. In this article, I Explain the Difference between Vector and Raster graphics with Examples.

What is the difference between Vector and Raster graphics?

Graphics are part of Multimedia. In Digital media like Photo, Video, Animation all these things are made by graphics. Graphics are two types Vector Graphics and Raster Graphics.

Vector Graphics

Raster Graphics

Vector Graphics are composed of paths. Raster graphics are composed of pixels.
Vector Graphics such as a.eps file or Adobe Illustrator file are composed of paths or lines, that are either straight or curved. Raster graphics Such as a .gif .jpeg is arranging of pixels of various colors, which together form an image.
The data file for a Vector image contains the points where the paths and ends how much the path curve, and the colors that either border or fill the paths. Raster graphics, on the other hand, become “blocky” since each pixel increases in size as the image is larger.
Vector Graphics is Capable of detailed editing. Raster graphics are Less detailed but offer precise paths.

Read Also: What is Multimedia in Computer With Example

Difference between Vector and Raster graphics with Example

Example of Vector Graphics Software with Format:

  1. Adobe Illustrator.
  2. CorelDraw.

Vector Graphics typically saved as EPS, AI, SVG, PDF Format.

Example of Raster graphics Software with Format:

  1. Adobe Photoshop.
  2. Gimp.

Raster Graphics saved as JPG, GIF, PNG, TIF, BMP Format.


I hope you get the all information about the difference between Vector and Raster graphics with Example. If you like this article, you can share and comment. So that we too have a chance to learn something from your ideas and improve something.

Read Also:

Continue Reading

trending