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

The CC Aurora is actually pretty fun, as far as projectors go

I don’t review projectors. Projectors are boring. Even the good ones. They remind me of vacation slideshows and the film strips we had to watch in health class — neither of which I’m in a particular hurry to revisit in my adult life. That said, I’ve always harbored some germ of a notion that some day I might buy one, to compensate for being one of those weirdos without a TV set. There’s something undeniably appealing about a big screen TV you can break out during movie night and then stash back into the closest of your one-bedroom New York City apartment. XGIMI’s CC Aurora is the closest I’ve seen to fitting the bill — or, for that matter, being a projector that I could actually muster any reasonable amount of excitement about. From the looks of it, it’s kind of the perfect package for the apartment dweller: it’s compact, self-contained with a built-in speaker system and plays nicely with mobile devices. Clearly I’m not alone here, either. The product scored $170,000 on Indi...

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...

Hundreds Of Apps Banned From App Store For Accessing Users’ Personal Information

Hundreds of iOS applications have been pulled out of the App Store, following a report from analytics service SourceDNA , which uncovered a group of applications that were extracting users’ personally identifiable information, including email addresses associated with their Apple IDs, devices and peripheral serial numbers, as well as a list of apps installed on their phone. The applications in question had been using an SDK from a Chinese advertising company called Youmi which was accessing this information by way of private APIs, the report found. Nearly all of the developers were located in China so, for now, this appears to be an isolated incident. However, the larger concern here has to do with how long this activity had been taking place – and what that means in terms of Apple’s App Store review process, given that it hadn’t caught this suspect activity until being alerted to it by a third party. According to SourceDNA, Yo...

Uber, Google and other tech employees form Coalition of Black Excellence

When black employee resource groups from a variety of tech companies come together, black magic happens. More specifically, black excellence happens. The Coalition of Black Excellence Week, spearheaded by Uber Litigation Counsel Angela Johnson in collaboration with black ERGs from over 40 tech companies like Facebook, Google, eBay, Lyft and Microsoft, kicks off this Monday in the San Francisco Yay (Bay) Area. The idea for CBE Week came in part from Johnson’s experiences living in Washington D.C., and being able to attend events put on by the Congressional Black Caucus, she told me at Uber’s headquarters this week. “When I moved out to the Bay Area, I really wished there were similar types of experiences for tech,” Johnson said. “And I thought if we could bring together different black ERGs, or diversity and inclusion committees, or people who were interested in some of the issues the black community is passionate about, a lot of positive change and impact could come from that....

Intel announces the first 14 nanometre processor

At the Computex conference in Taipei, chipmaker Intel has revealed a fanless mobile PC reference design using the first of its next-generation 14nm "Broadwell" processors. The 2 in 1 pictured here is a 12.5" screen that is just 7.2 mm thick with keyboard detached and weighs 670 grams. The Surface Pro 3 – for comparison – is 9.1 mm thick and weighs 800 grams. It includes a media dock that provides additional cooling for a burst of performance. The next-generation chip is purpose-built for 2 in 1s and will hit the market later in 2014 . Called the Intel Core M, it will be the most energy-efficient Intel Core processor in the company's history with power usage cut by up to 45 percent, resulting in 60 percent less heat. The majority of designs based on this new chip are expected to be fanless, with up to 32 hours of battery life, offering both a lightning-fast tablet and razor-thin laptop. Intel is also delivering innovation and performance for the ...

Exciting Technology

Search This Blog