How to use mail merge in Microsoft Word 2007

Mail MergeMail Merge is a valuable apparatus that will enable you to effectively deliver various letters, names, envelopes, and all the more utilizing data put away in a rundown, database, or spreadsheet. In this lesson, you will figure out how to utilize the Mail Merge Wizard to make an information source and a frame letter, and investigate other wizard highlights. Furthermore, you will figure out how to utilize the Ribbon summons to get to Mail Merge devices outside of the wizard.



To utilize Mail Merge:

  • Select the Mailings on the Ribbon.
  • Select the Start Mail Merge summon.

Mail Merge

  • Select Step by Step Mail Merge Wizard.

The Mail Merge undertaking sheet shows up and will manage you through the six principle ventures to finish a consolidation. You will have a few choices to make amid the procedure. The accompanying is a case of how to make a shape letter and consolidation the letter with an information list.

Stages 1-3

  • Pick the sort of archive you need to make. In this illustration, select Letters.
  • Snap Next:Starting archive to move to Step 2.
  • Select Use the present archive.
  • Snap Next:Select beneficiaries to move to Step 3.
  • Select the Type another rundown catch.
  • Snap Create to make an information source. The New Address List exchange box shows up.
    • Snap Customize in the exchange box. The Customize Address List discourse box shows up.
    • Select any field you don’t need, and snap Delete.
    • Snap Yes to affirm that you need to erase the field.
    • Keep on deleting any pointless fields.
    • Snap Add. The Add Field exchange box shows up.
    • Enter the new field name.
    • Snap OK.
    • Keep on adding any fields vital.
    • Snap OK to close the Customize Address List discourse box.

To redo the new address list:

Mail Merge

  • Enter the vital information in the New Address List exchange box.
  • Snap New Entry to enter another record.
  • Snap Close when you have entered the greater part of your information records.
  • Enter the document name you need to spare the information list as.
  • Pick the area where you need to spare the record.
  • Snap Save. The Mail Merge Recipients discourse box shows up and shows the greater part of the information records in the rundown.
  • Affirm that the information list is right, and snap OK.
  • Snap Next:Write your letter to move to Step 4.

Stages 4-6

  • Compose a letter in the present Word report, or utilize an open existing record.

To embed beneficiary information from the rundown:

  • Place the inclusion point in the report where you need the data to show up.
  • Select Address piece, Greeting line, or Electronic postage from the errand sheet. A discourse box with alternatives will seem in light of your choice.

Merge Fields


  • Select More Items. The Insert Merge Field discourse box will show up.
  • Select the field you need to embed in the archive.
  • Snap Insert. Notice that a placeholder shows up where data from the information record will in the end show up.
  • Rehash these means each time you have to enter data from your information record.
  • Snap Next: Preview your letters in the assignment sheet once you have finished your letter.
  • See the letters to ensure the data from the information record shows up accurately in the letter.
  • Snap Next: Complete the union.
  • Snap Print to print the letters.
  • Snap All.
  • Snap OK in the Merge to Printer discourse box.
  • Snap OK to send the letters to the printer.

The Mail Merge Wizard enables you to finish the union procedure in an assortment of ways. The most ideal approach to figure out how to utilize the distinctive capacities in Mail Merge is to attempt to build up a few of the diverse reports—letters, names, and envelopes—utilizing the distinctive kinds of information sources.

For more articles visit : Office Setup

How to Use Excel Vlookup Function – Microsoft Excel

A considerable lot of our students have revealed to us they need to figure out how to utilize Excel’s VLOOKUP work. VLOOKUP is a greatly valuable apparatus, and figuring out how to utilize it is less demanding than you might suspect!

Before you begin, you ought to comprehend the fundamentals of capacities. Look at our Functions lesson from our Excel Formulas instructional exercise (or select a particular rendition of Excel). VLOOKUP works the same in all adaptations of Excel, and it even works in other spreadsheet applications like Google Sheets. You can download the case in the event that you’d get a kick out of the chance to work alongside this article.

What precisely is VLOOKUP?

Essentially, VLOOKUP gives you a chance to scan for particular data in your spreadsheet. For instance, in the event that you have a rundown of items with costs, you could scan at the cost of a particular thing.

We will utilize VLOOKUP to discover the cost of the Photo outline. You can presumably as of now observe that the cost is $9.99, yet that is on the grounds that this is a straightforward illustration. When you figure out how to utilize VLOOKUP, you’ll have the capacity to utilize it with bigger, more unpredictable spreadsheets, and that is the point at which it will turn out to be really helpful.


We’ll add our recipe to cell E2, yet you can add it to any clear cell. Similarly as with any equation, you’ll begin with an equivalents sign (=). At that point write the equation name. Our contentions should be in enclosures, so write an open bracket. Up until now, it should resemble this:


Including the arguments

Presently, we’ll include our contentions. The contentions will disclose to VLOOKUP what to look for and where to seek.

The principal contention is the name of the thing you’re hunting down, which for this situation is Photo outline. Since the contention is content, we’ll have to place it in twofold statements:

=VLOOKUP(“Photo outline”

The second contention is the cell extend that contains the information. In this illustration, our information is in A2:B16. Similarly as with any capacity, you’ll have to utilize a comma to isolate every contention:

=VLOOKUP(“Photo outline”, A2:B16

Note: It’s imperative to realize that VLOOKUP will dependably look through the main section in this range. In this illustration, it will look section A for “Photograph outline”. Sometimes, you may need to move the segments around so the principal segment contains the right information.

The third contention is the section file number. It’s less complex than it sounds: The principal section in the range is 1, the second segment is 2, and so on. For this situation, we are attempting to discover the cost of the thing, and the costs are contained in the second segment. This implies our third contention will be 2:

=VLOOKUP(“Photo outline”, A2:B16, 2

The fourth contention discloses to VLOOKUP whether to search for inexact matches, and it can be either TRUE or FALSE. On the off chance that it is TRUE, it will search for rough matches. By and large, this is just helpful if the primary segment has numerical esteems that have been arranged. Since we’re searching for correct matches, the fourth contention ought to be FALSE. This is our last contention, so simply ahead and close the enclosures:

=VLOOKUP(“Photo outline”, A2:B16, 2, FALSE)

That is it! When you press Enter, it should give you the appropriate response, which is 9.99.

screenshot of Microsoft Excel

How it functions

How about we investigate how this equation functions. It initially seeks vertically down the principal section (VLOOKUP is short for vertical query). When it discovers “Photograph outline”, it moves to the second section to discover the cost.

In the event that we need to discover the cost of an alternate thing, we can simply change the main contention:

=VLOOKUP(“T-shirt”, A2:B16, 2, FALSE)

or on the other hand:

=VLOOKUP(“Gift bushel”, A2:B16, 2, FALSE)

Office Setup : Blogs

How to add Signature – Microsoft Outlook

Making an email signature

An email signature comprises of content as well as pictures that are consequently added to the finish of active email messages. You can make numerous custom marks for various gatherings of people, for example, for business contacts or close companions. Business email marks ordinarily contain your name, work title, and business contact data. Your own email mark may incorporate a photo, shutting welcome, quote, or some other data. There are no tenets for what data you can incorporate into your mark.

To make an email signature:

  • Select ToolsactionOptions from the principle menu. The Options exchange box will show up.
  • Select the Mail Format tab.
  • Tap the Signatures catch in the Signatures area.
  • Snap New. The Create New Signature discourse box will show up.
  • Enter a name for your mark. In the case beneath, the mark is named “Business”.

Business Signature

  • Select Start with clear signature. On the off chance that you have a current mark spared in Outlook or as a document on your PC, you can utilize it as a layout now.
  • Snap Next. The Edit Signature exchange box will show up.
  • Sort the content you need as your email signature.
  • Feature the content utilizing your mouse.
  • Snap Font. The Font exchange box will show up.
  • Select the textual style, style, size, and shading you need to arrange your mark.
  • Snap OK. The organized mark will show up in the Edit Signature discourse box.

Formatted Signature

  • Audit the mark and confirm that it shows up as you need.
  • Snap Finish.
  • Snap OK in the Create Signature discourse box.
  • Snap OK in the Options discourse box. Your mark will now naturally seem each time you make another email message.

For more posts visit :-

Query Design Options in Microsoft Access


Access offers a few choices that let you outline and run questions that arrival precisely the data you’re searching for. For example, consider the possibility that you have to discover what number of something exists inside your database. For sure on the off chance that you might want your question results to consequently be arranged a specific way? On the off chance that you know how to utilize Access’ inquiry choices, you can outline any question you need.

Video: Modifying Queries

Launch "Modifying Queries" video!

In this lesson, you’ll figure out how to adjust and sort your questions inside Query Design see, and also how to utilize the Totals capacity to make an inquiry that can perform figurings with your information. You’ll likewise find out about extra inquiry building choices offered in Access.

All through this instructional exercise, we will utilize an example database. On the off chance that you might want to take after along, you’ll have to download our Access 2013 example database. You should approach 2013 introduced on your PC keeping in mind the end goal to open the illustration.

Changing inquiries

Access offers a few choices for improving your inquiries work for you. Notwithstanding changing your inquiry criteria and joins after you fabricate your questions, you can sort and conceal fields in your inquiry comes about.

To alter your inquiry:

When you open a current inquiry in Access, it is shown in Datasheet see, which means you will see your question brings about a table. To alter your inquiry, you should enter Design see, the view you utilized while making it. There are two approaches to change to Design see:

  • On the Home tab of the Ribbon, tap the View order. Select Design View starting from the drop menu that shows up.

Screenshot of Access 2013

  • In the base right corner of your Access window, find the little view symbols. Tap the Design View symbol, which is the symbol most distant to one side.

Screenshot of Access 2013

Once in Design see, roll out the coveted improvements, at that point select the Run order to see your refreshed outcomes.

You may see that Access likewise offers SQL see. You can disregard this. SQL see enables you to make propelled capacities that you won’t have to use for this instructional exercise or for most Access capacities.

Arranging inquiries

Access enables you to apply various sorts without a moment’s delay while you’re planning your question. This enables you to see your information precisely the way you need.

A sort that incorporates in excess of one arranged field is known as a multilevel sort. A multilevel sort enables you to apply an underlying sort, at that point additionally arrange information with extra sorts. For example, on the off chance that you had a table loaded with clients and their locations, you may decide to first sort the records by city, at that point one after another in order by last name.

At the point when in excess of one sort is incorporated into an inquiry, Access peruses the sorts from left to right. This implies the furthest left sort will be connected first. In the case underneath, clients will be arranged first by the City where they live and after that by the Zip Code inside that city.

Screenshot of Access 2013

To apply a multilevel sort:

  • Open the inquiry and change to Design see.
  • Find the field you need to sort first. In the Sort: push, tap the drop-down bolt to choose either an Ascending or Descending sort.

Screenshot of Access 2013

  • Rehash the procedure in alternate fields to include extra sorts. Keep in mind, the sorts are connected from left to right, so any extra sorts must be connected to fields situated to one side of your essential sort. On the off chance that important, you can improve the fields by tapping the highest point of a field and dragging it to another area.

Screenshot of Access 2013

  • To apply the sort, tap the Run charge.

Screenshot of Access 2013

  • Your inquiry results will show up with the coveted sort.

Screenshot of Access 2013

You can likewise apply multilevel sorts to tables that don’t have inquiries connected to them. On the Home tab on the Ribbon, select the Advanced drop-down order in the Sort and Filter gathering. From the menu that shows up, select Advanced Filter/Sort and make the multilevel sort as you regularly would. When you’re done, tap the Toggle Filter summon to apply your sort.

Screenshot of Access 2013

Concealing fields inside inquiries

Once in a while you may have fields that contain imperative criteria, yet you should not have to really observe the data from that field in the last outcomes. For instance, take one of the questions we worked in our last lesson: an inquiry to discover the names and contact data of clients who had put orders. We included Order ID numbers in our inquiry since we needed to ensure we just pulled clients who had put orders.

Notwithstanding, we truly didn’t have to see this data in our last inquiry comes about. Truth be told, in the event that we were simply searching for client names and addresses, seeing the request number blended in there might have been diverting. Luckily, Access makes it simple to shroud fields while as yet including any criteria they contain.

To conceal a field inside a question:

  1. Open the question and change to Design see.
  2. Find the field you need to cover up.
  3. Tap the checkbox in the Show: column to uncheck it.Screenshot of Access 2013
  4. To see the refreshed question, select the Run charge. The field will be covered up.

To unhide a concealed field, essentially come back to Design view and tap the checkbox in the field’s Show: push once more.

Office Com Setup : Blogs

Microsoft PowerPoint WordArt And Shapes




PowerPoint 2007 Word Art and ShapesPowerPoint 2007 Word Art and Shapes There are numerous highlights and orders you can use in PowerPoint to make outwardly engaging slides. Two of these highlights are WordArt and shapes. WordArt enables you to make adapted content with surfaces, shadows, and blueprints. It can be connected to content on any slide. Furthermore, in PowerPoint you can embed an assortment of shapes, for example, lines, bolts, callouts, stars, and fundamental shapes, including rectangles and circles.

In this lesson, you will figure out how to apply and change WordArt styles, and also how to embed and adjust different shapes on a slide.


To apply a WordArt style:

  • Select the content you need to change. The Format tab will show up.
  • Select the Format tab.
  • Move your cursor over a WordArt style in the WordArt Styles gathering to see a live review of the style on the slide.

WordArt Styles

  • Tap the More drop-down bolt to see all conceivable WordArt styles.

More WordArt Styles

  • Snap an alternative to choose it.

To change the fill shade of a WordArt style:

  • Select the content you need to change.
  • Tap the Text Fill charge in the WordArt Styles gathering.

WordArt Fill Command

  • Move your cursor over a shading choice to see a live review on the slide.
  • Snap a shading to choose it.

Or on the other hand select from the accompanying:

  • No Fill: This alternative will leave the WordArt content without a fill shading.
  • More Fill Colors: This opens a discourse box of shading decisions you can use as a fill shading.
  • Picture: This opens the Insert Picture discourse box. From here, you can choose a photo from your PC to use as the fill foundation.
  • Slope: This shows a submenu of different inclination choices that change how the fill shading shows up.
  • Surfaces: This shows a submenu of different surfaces you can apply to WordArt content.

Working with WordArt

To change the content blueprint of a WordArt style:

  • Select the content you need to alter. The Format tab will show up.
  • Select the Format tab.
  • Tap the Text Outline order in the WordArt Styles gathering.

Text Outline

  • Move your cursor over a shading alternative to see a live review on the slide.
  • Snap a shading to choose it.

From the Text Outline menu, you can likewise apply no blueprint shading, get to more hues, change the heaviness of the line, and change the line style.

To apply a content impact to a WordArt style:

  • Select the content you need to adjust. The Format tab will show up.
  • Select the Format tab.
  • Tap the Text Effects summon. A menu of choices will show up.
  • Select a menu choice. The choices are Shadow, Reflection, Glow, Bevel, 3-D Rotation, and Transform. Each will show a submenu.

Text Effects

  • Snap a choice from the submenu to choose it.

You can utilize WordArt to make adapted content that is attractive and proficient; in any case, with such a significant number of styles and choices, you can likewise make message that isn’t suitable for an introduction, that is hard to peruse, or that essentially does not look engaging. Keep in mind, since you can accomplish something doesn’t mean you should!

To embed a shape:

Select the Home tab.

  • Tap the Shapes charge.
  • Snap a shape from the menu.
  • Embed Shape

Insert Shape

  • Move your cursor toward the slide. It will appear as a cross shape.
  • Snap and hold down the mouse catch, and drag the cursor until the point when the shape is the coveted size.

Shape Cursor

  • Discharge the mouse catch to embed the shape.

To change a shape style:

  • Select the shape. The Format tab will show up.
  • Select the Format tab.
  • Tap the More drop-down bolt in the Shapes Style gathering to show more style alternatives.

Shape Style

  • Move your cursor over a style to see a live review of the style on the slide.
  • Snap a style to choose it.

Working with shapes

To change the shape fill:

  • Select the shape. The Format tab will show up.
  • Select the Format tab.
  • Tap the Shape Fill charge to show a drop-down rundown.
  • Select a shading from the rundown, or pick one of the other menu choices.

Shape Fill

To change the shape layout:

  • Select the shape. The Format tab will show up.
  • Select the Format tab.
  • Tap the Shape Outline charge to show a drop-down rundown.
  • Select a shading from the rundown, or pick one of the other menu alternatives.

Shape Outline

To apply a shape impact:

  • Select the shape you need to alter. The Format tab will show up.
  • Select the Format tab.
  • Tap the Shape Effects order.
  • Move your cursor over a menu alternative. A submenu will show up.
  • Move your cursor over a choice in the submenu to see a live review of the impact on the slide.

Shape Effect

  • Snap an alternative to choose the shape impact.

You can resize and move the shape simply like you would with content boxes and pictures. : Blogs

Utilizing the Format Painter in Microsoft PowerPoint and Word


Topics can be an extraordinary method to make your Microsoft PowerPoint introduction or Word report look decent, however now and again you should need to add hand craft components to your undertaking. Custom designing can be repetitive, however, particularly when you’re completing a considerable measure of it. For example, take this Microsoft PowerPoint slide. Suppose you’ve connected a progression of impacts to the photograph on the left, and now you’d jump at the chance to do likewise to the photograph on the right.

Screenshot of Microsoft PowerPoint

You could endeavor to recall the greater part of the impacts connected and apply them to the second photograph also—or you could spare some time and utilize the Format Painter. The Format Painter is an instrument in Word and PowerPoint that gives you a chance to duplicate the greater part of the organizing starting with one question and apply it then onto the next one. Consider it reordering for organizing.

Utilizing the Format Painter

Select the protest with the arranging you need to duplicate.

Screenshot of Microsoft PowerPoint

Tap the Format Painter symbol. It might be situated in a marginally better place, contingent upon your variant of Office, however it generally resembles a paintbrush.

Screenshot of Microsoft PowerPoint

Select the question you need to apply the organizing to. The protest will be organized.

Screenshot of Microsoft PowerPoint

Could it be any more obvious? Basic! That was substantially speedier than applying the individual impacts each one in turn. In the event that you need, you can even utilize the Format Painter to apply the designing to different articles. Simply double tap the Format Painter symbol as opposed to clicking it once.

Screenshot of Microsoft PowerPoint

Despite the fact that we just took a gander at utilizing the Format Painter for photographs in PowerPoint, you can utilize it for anything you can apply designing to in Word or Microsoft PowerPoint. This incorporates content, table cells, and shapes. When you begin utilizing it, you’ll be astounded how regularly it proves to be useful. You may even add it to your Quick Access Toolbar to make it considerably less demanding to utilize!

Microsoft Word Instructions to make a chapter


Envision you’re working with an extremely long record in Microsoft Word, similar to a scholastic paper or a major report. Contingent upon the task, it may be handfuls or even many pages long! At the point when a report is this expansive, it can be hard to recall which page has what data. Luckily, Microsoft Word enables you to embed a list of chapters, making it simple to arrange and explore your archive.

A list of chapters is much the same as the rundown of parts toward the start of a book. It records each area in the archive and the page number where that segment starts. An extremely essential list of chapters may resemble this:

Screenshot of Microsoft Word

You could make a chapter by chapter guide physically—composing the segment names and page numbers—however it would take a great deal of work. Also, on the off chance that you ever choose to modify your areas or include more data, you’ll need to refresh everything once more. Be that as it may, with the correct arranging, Microsoft Word can make and refresh a chapter by chapter list consequently.

We’ll utilize Microsoft Word 2013 to demonstrate to you generally accepted methods to make a chapter by chapter guide, yet you can utilize precisely the same in Microsoft Word 2010 or Microsoft Word 2007.

Stage 1: Apply heading styles

On the off chance that you’ve just perused our Styles lesson, you know they’re a simple method to add proficient content arranging to various parts of your record. Styles additionally fill another imperative need: including a concealed layer of association and structure to your record.

In the event that you apply a heading style, you’re disclosing to Microsoft Word that you’ve begun another piece of your report. When you embed the chapter by chapter guide, it will make an area for each heading. In the list of chapters over, every part utilizes a heading style, so there are four areas.

To apply a heading style, select the content you need to organize, at that point pick the coveted heading in the Styles bunch on the Home tab.

Screenshot of Microsoft Word

Stage 2: Insert the chapter by chapter list

Presently for the simple part! Once you’ve connected heading styles, you can embed your chapter by chapter list in only a couple of snaps. Explore to the References tab on the Ribbon, at that point tap the Table of Contents charge. Select an inherent table from the menu that shows up, and the chapter by chapter list will show up in your report.

Screenshot of Microsoft Word

As should be obvious in the picture underneath, the list of chapters utilizes the heading styles in your archive to figure out where each segment starts. Areas that start with a Heading 2 or Heading 3 style will be settled inside a Heading 1 style, much like a multilevel rundown.

Screenshot of Microsoft Word

A chapter by chapter guide additionally makes joins for each area, enabling you to explore to various parts of your record. Simply hold the Ctrl key on your console and snap to go to any segment.

Screenshot of Microsoft Word

Stage 3: Update as required

On the off chance that you alter or add to your report, it’s anything but difficult to refresh the chapter by chapter guide. Simply select the list of chapters, click Update Table, and pick Update Entire Table in the discourse box that shows up. The list of chapters will then refresh to mirror any progressions.

Screenshot of Microsoft Word

Regardless of how vast your archive might be, you can see there’s nothing convoluted about making a list of chapters. In the event that you need significantly more control over how your list of chapters shows up, look at this instructional exercise from Microsoft on Taking a Table of Contents to the Next Level.

For More Posts :