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

eGym raises $45M Series C for cloud-connected gym equipment and fitness software

eGym , the Munich-based startup that offers cloud-connected gym equipment and supporting cloud software and app for the fitness training floor, has closed $45 million in Series C funding. The round was led by new investor HPE Growth Capital, while existing investors, including Highland Europe, also participated. The problem that eGym is looking to solve is that, whilst gyms have moved from a bodybuilder market to a mass market in the last 20 years, the technology in gyms lags behind. That’s despite the fact that better use of technology can help to reduce customer churn, the biggest pain-point of both gym operator and gym users. Comprising of an app for both gym user and trainer, combined with the company’s connected strength machines, the eGym Cloud makes it possible for gym members to receive better fitness instruction and an evolving and personalised fitness plan based on data collected as they workout. And by providing a better workout feedback loop, gym goers can get an i...

Building a smarter home

The Jetsons presented a highly entertaining vision of what homes of the future would look like . The animated television show anticipated a world where humans would be able to do everything with just the push of a button. In many ways, the show turned out to be prophetic; today we have printable food, video chats, smartwatches and robots that help with housework — and flying cars may even be on the way. The challenge for companies is to integrate digital technologies in meaningful ways that enhance people’s homes and improve their lives. Many of the innovations to emerge over the past few years have been geared toward this kind of “push-button living.” Thanks to the rise of smartphones and the proliferation of cheap sensors, it is possible to make just about any household appliance “smart” and “connected.” By 2019, companies are expected to ship 1.9 billion connected home devices, bringing in about $490 billion in revenue. ...

Careless USB removal causes multiple deaths

EIGHTEEN workers have died after a USB stick was removed from a computer without adequate precautions. The offices of Hereford-based Envision Photography were completely destroyed in the ensuing blast. Survivor Norman Steele said: “My colleague Helen had put some files on the stick to work on at home, and she yanked it out of the computer before anyone could scream ‘no’. “I kicked her aside as a jet of white-hot flame belched out of the USB port and set fire to the desk opposite. “Grabbing her, I dived through the window just before all the PCs in the network exploded with purple electricity that fried everyone in the building. “I sprinted to my car, knowing that the printers were already becoming merciless hunter-killer drones, shouting for Helen to follow. “But when I looked round I saw her frozen, something glowing in her hand, the awareness dawning of her fate. She was still holding the USB. “She detonated in a flash of ultraviolet light that turned eve...

What will a driverless future actually look like?

There is a growing consensus that autonomous vehicles (AVs) will soon be a reality. The debate today centers not on whether, but how soon, AVs will be commonplace on our roads. But for all the buzz surrounding AVs, many details about what a driverless future will look like remain unclear. Which business models will work best for the commercialization of AVs? Which AV usage models will be most appealing for consumers? Which companies are best positioned to win in this new market? These are big questions, and no certain answers can be given at this stage. Nonetheless, it is valuable to reflect, in a concrete way, on how this transformative technology might develop. This article will present some conjectures. The end of private car ownership? At a high level, two possible paradigms seem most likely for how society will use AVs. The first is private AV ownership. Under this model, individuals or families would continue to own their own vehicles and use them to get a...

Airbnb will open its Cuba listings to users outside the United States

Airbnb will now let travelers from outside the U.S. to book properties in Cuba after receiving authorization from the U.S. government, reports the Associated Press . Previously, only Americans were allowed to reserve the site’s Cuban listings . They will open to international users on April 2. Airbnb launched its Cuban operations in April 2014 , four months after the Obama administration revealed that it will begin to restore diplomatic relations with the Communist country . The historic policy change means that travel and trade sanctions will be lifted , which is expected to boost tourism to Cuba dramatically because Americans no longer need licenses to visit. In fact, President Obama is currently on an official visit to Cuba , the first president since Calvin Coolidge to do so. According to the AP, Cuba is currently Airbnb’s fastest-growing market, with about 4,000 homes added since it opened listings. Other travel businesses...

Exciting Technology

Search This Blog