HOW TO USE MAIL MERGE IN WORD

Mail Merge of Microsoft Windows can save lot of you time if you want to create a form letter for your customers or this is one of the task that must complete in your work.

Mail Merge is used when you want to create set of documents or a form letter that is sent to many customers. For example you want to create a form letter which has the same information except from the name of the customers. You can personalize each letter to addrees each customer by name.

Before start if you have lot of customers or email address it's preferred to create a separate Excel with the specific details.

Are you ready to start?

Open in your Word the Form Letter that you want to sent in your customers.
From the Menu Bar go in Tab Mailiing and click on Start Mail Merge.
Select Step-by-Step Mail Merge Wizard.

It will open a new section from the left side.
In Select Document Type kepp the default option (Letter) for the specific Example. You can use and othe options as Email messages,Labels,Evnelopes and so on.
Go in the bottom and click Next :Starting Document.

In Select Starting Document use the default option <Use the current document>
Go again in bottom and click Next:Select Recipients.

In Select Recipients use the default option <Use an existing list>.
In Use an existing List click Browse.
Find your Excel file with your customers and click Open.
Click OK

And again OK.

Go in the bottom and click Next : Write Your Letter

Before proccedd select the area from your Document that you want to copy the addreess of your customer name or email address or anything else.

In Write your letter click More Items.
Select the first field Name and click Insert.
You will see that in the selected area will be change as <<Name>>. This is the area that will copy the data from the field.
Click Close

Clcik again More Items aNd Do the same for any other field that you have to insert.
When you finish click Close, Go in the right bottom side and click Preview Your letters.

Check that the selected Areas which insert the field preview the data from the Excel.

When verify tha all is ok go in the bottom and clcik Complete the merge.

Click Edit Individual Letters.

Base on the customers that you have in the Excel the Word will be create x Pages with the same Letter and different data in the selected area that you inserted.
Click Save and you are Ready.

You can save lot of time when you work with Form Letters or want to send multiple emails in the customers with specific Email Template.

That's it for now. Let's have nice weekend and i will be back in 8 days with new articles.

If you have any question or idea write your comments here in Google+ or Twitter.

Comments

How ad-free subscriptions could solve Facebook

At the core of Facebook’s “well-being” problem is that its business is directly coupled with total time spent on its apps. The more hours you pass on the social network, the more ads you see and click, the more money it earns. That puts its plan to make using Facebook healthier at odds with its finances, restricting how far it’s willing to go to protect us from the harms of over use. The advertising-supported model comes with some big benefits, though. Facebook CEO Mark Zuckerberg has repeatedly said that “We will always keep Facebook a free service for everyone.” Ads lets Facebook remain free for those who don’t want to pay, and more importantly, for those around the world who couldn’t afford to. Ads pay for Facebook to keep the lights on, research and develop new technologies, and profit handsomely in a way that attracts top talent and further investment. More affluent users with more buying power in markets like the US, UK, and Canada command higher ad prices, effectively...

Windows 7 and 8.1 Update to Windows 10 automatically

Windows 10 downloader While it might be a bit too early to start getting excited over the Windows 10 update , which isn't expected to arrive until summer, Microsoft seems to already be warming up people's computers just the same. A recommended, and therefore purely optional, update for Windows 7 Service Pack 1 and Windows 8.1 has been discovered to be laying the groundwork for those machines' eventual upgrade to Windows 10. Although the Windows 10 release date was not announced officially, the details of this update also reveal how Microsoft might try to convince users to update to the latest Windows 10 version. The KB3035583 update "enables additional capabilities for Windows Update notifications when new updates are available to the user", which sounds pretty common. That is, until you dig into the update files and see a certain GWXUXWorker.exe which, upon further inspection, would actually "Download Windows 10". So this rather ...

Anyline Raises €1.5M To Let You Add Optical Character Recognition To Your App

Anyline , the Austrian startup that provides mobile OCR tech to enable developers to add text recognition to their own apps, has raised €1.5 million in funding. The list of investors is interesting, too. It includes angel investor Johann ‘Hansi’ Hansmann, busuu co-founder Bernhard Niesner, Lukas Püspök, and the U.S.-based VC-fund iSeed Ventures. However, most notable is that the round was led by Gernot Langes-Swarovski Group. As one investor put it to me, “the fact that the Swarovski family led the round shows that finally ‘old’ money is moving into Austrian startups”. Offering its own mobile Optical Character Recognition (OCR) technology — which uses a smartphone’s camera to accurately scan and recognise any kind of text, code or number — Anyline co-founder and CEO Lukas Kinigadner tells me the startup is built on the premise that “people screw up a lot”. “Mistakes happen easily when you’re writing down a 10-digit-number and then have to type it in again a few moments later...

Three Reasons Why You Need Better Personal Cyber security

From the infamous Sony hack to the recent WannaCry virtual catastrophe that affected over 300,000 computers, the need for reliable personal cyber security has never been more apparent. Rubica's skilled team of experts want to remind every one of the importance of cyber security and the three reasons why it is becoming a more pressing issue every day. With top-notch personal cyber security, most attacks are preventable. 1. Larger Number Of Attacks Americans have heard of the most notable attacks on major corporations or government entities over the past several years. However, most people who are not in the information security field do not learn just how much the attack frequency is growing. The number of cyber attacks carried out worldwide in 2015 was quadruple a number of attacks recorded in 2013. Although the cost associated with the number of annual recorded attacks is in the $500 billion range right now, experts say that it will grow well into the trillions by ...

Insure Your Family by Controlling Devices Through an App

AIR: YOUR SMART HOME Have you ever rushed to your house suspecting that you may have accidently kept the iron turned on? How do you deter a burglar from breaking into your house? You probably would rush to your house and manually turn off the switch in the first instance, and get a burglar alarm for the next. But what if there were a single solution for both? Humans are delegating a lot of menial and repetitive tasks to machines. And as far as errands in your house and offices are concerned, the good news is – you can control appliances through your smart phone. INTRODUCING AIR: YOUR SMART HOME Air app, which is available on both Android and Apple platforms, interacts with your devices and switches them off with a single tap. AIR MOBILE APP The app is complemented with a package that consists of a pentagonal-shaped unit and switchboard module. Once you install air unit; your smartphone can interact with it using the Air App. Thereafter, the unit instructs the...

Exciting Technology

Search This Blog