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

Google Announces Android Wear Update With WiFi Support, Always-On Apps, And More

It has been a while since Android Wear got any substantial updates, but today Google is announcing a big one. A new version of Wear will be rolling out over the coming weeks that includes a number of previously rumored features (like WiFi support) and some all new stuff (like always-on apps). Most Wear devices use the always-on ambient mode for the watch face by default, the Moto 360 being a notable exception. The new Android Wear version allows apps to operate in ambient mode too, so they remain active when the watch goes to sleep. That makes it easier to take a quick glance at the app instead of waking the device up and opening the app all over again. The watch will still only go into full-color mode when necessary. WiFi support is also coming in the update, which means your watch can be useful even if your phone isn't connected. Watches with WiFi support will be able to connect to WiFi and still get messages and notifications from your phone, provided it has an interne...

The Eight Most Impactful Excel Shortcuts That You Should Master

If you’ve ever gone online to research improving your Excel skills, you’ve undoubtedly come across a post or two listing all of Excel’s keyboard shortcuts. In the latest version of Excel, Microsoft has made it easier than ever to learn shortcuts, by assigning shortcuts to nearly every function and making the discovery of the input sequence very transparent. While memorizing Excel shortcuts will generally improve your productivity, not all shortcuts are created equal. Shortcuts that you never use are not inherently not very useful and not worth memorizing. Your focus should be on the shortcuts that have the most impact – either by the amount of time it saves you, the frequency that you’ll use them, or the behavior it encourages. If you’ve already started using Excel or just haven’t utilized shortcuts heavily before, review the top eight shortcuts below. For any that you don’t know already, I would suggest memorizing them and incorp...

Facebook will verify the location of U.S. election ad buyers by mailing them postcards

Facebook’s global director of policy programs says it will start sending postcards by snail mail to verify buyers of ads related to United States elections. Katie Harbath, who described the plan at a conference held by the National Association of Secretaries of State this weekend, didn’t reveal when the program will start, but told Reuters that it would be before the Congressional midterm elections in November. The cards will be sent to people who want to purchase ads that mention candidates running for federal offices, but not issue-based political ads, Harbath said, and contain a code that buyers need to enter to verify that they are in the U.S. The program is similar to ones used by Google My Business and Nextdoor when they need to verify business owners or users who want to join closed neighborhood groups, respectively. Harbath told Reuters that the postcards “won’t solve everything,” but were the most effective method the company came up with to prevent people from using fa...

How Education Will Be Smarter, Less Intrusive, And Able To Respond To How You Feel

Impatience characterizes the technology sector’s approach to education. Disruption is taking place in all other sectors of society — so, why not education? I know too well, whether at Pearson or in the classroom, the challenges and frustration of developing and using digital tools that improve outcomes for students. But I’m optimistic. We are on the verge of a tide of smarter innovation that, if allowed to spread, will turbocharge the learning experience for students. Here are four areas worth watching: 1. Using technology to learn from learners Every great digital product constantly evolves by learning from its users, adding capabilities, and improving its performance. If it’s true for your Facebook feed, then why not education? The potential is there, as the OECD’s recent report on Students, Computers and Learning (OECD) incidentally showed how clickstream and tracking navigation in digital readers can be used to see how students process online text and...

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