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

Five budget-friendly open source storage servers

Storage is essential for the enterprise: Data must be stored. Data must be retrieved. Data must be shared. Data must be secured. At the same time, storage must not consume the entirety of your IT budget. Fortunately, you can find effective solutions in the world of open source. Outside of cost effectiveness, one of the biggest benefits of these solutions is the ability to modify them to perfectly fit your needs. You can make minor changes or even roll your own storage solution based on one of these tools. If you want enterprise support and a "solution in a can" that will meet just about any enterprise storage need, you should turn to Red Hat or SUSE. Both Linux-based companies offer some of the most powerful enterprise-ready tools on the market. But if you'd rather get your hands dirty and craft something of your own—something that won't demolish your budget—these five open source tools are a great place to start. 1: ownCloud ownCloud ( Figure ...

Apple Releases First Battery Case To Eat Third-Party Accessory Makers’ Lunch

In a surprise move, Apple just announced an external battery case for the iPhone 6s. Named the iPhone 6s Smart Battery Case , the battery extends the battery life of your iPhone 6s by up to 25 hours. The new accessory is available in black and white for $99 starting today. Let’s start with the design. Apple is using silicone as the main material like on its other cases. The company doesn’t disclose the capacity of the battery except that you’re supposed to get 18 to 25 hours of extra battery. Like third-party battery cases, Apple uses a Lightning male port at the bottom to plug your iPhone. You can charge the case using a traditional Lightning cable — most third-party batteries rely on a microUSB cable. Apple’s accessory also works with the iPhone 6 and it looks like there isn’t a 6 Plus and 6s Plus version. The Smart Battery Case features an unfortunate hump at the back. Mophie’s Juice Pack design is a bit sleeker compared to Apple’s official accessory. Apple...

Google Announces “Purchases On Google” For Buying Straight From PLAs And Other Mobile Shopping Updates

The much-anticipated buy button in Google search ads is finally here. Called Purchases On Google, it turns out the new feature isn’t a button at all. “Buy on Google” messaging will appear in eligible product listing ads on both iOS and Android smartphones. Purchases on Google is launching in a very limited pilot with select retailers. When consumers click on Purchases On Google-enabled ads, they’ll be taken to a page hosted by Google where they can make a purchase using payment criteria stored with Google. The orders are then passed through to the retailer for fulfillment and any customer service follow up. Check out our full coverage where you’ll find many more details about Purchases On Google on our sister site Marketing Land. Google also announced several of other updates to mobile PLAs: New Mobile Shopping Ad Formats For Voice Search When consumers use voice search to find products, Google is starting to show...

Visa confirms Coinbase wasn’t at fault for overcharging users

Yesterday, we wrote that Coinbase customers were being charged multiple times for past transactions. While some speculated that the erroneous withdraws were down to a Coinbase engineering issue, Coinbase issued a statement saying it wasn’t liable for the duplicate charges. The blame, instead, rested with Visa for the way it handled a migration of merchant categories for cryptocurrencies, Coinbase said. While you can read my post yesterday for an in-depth description of what happened, the basic gist is that Visa refunded and recharged (under a different merchant category) a month of old transactions. Many users saw the recharge come through before the refund processed, making it look like they were double charged. Honestly, the issue was likely exacerbated by existing payment rails — it’s normal for refunds to take multiple days to show up on credit and debit statements. But here’s where it gets weird — this morning Visa issued a statement to some publications shifting the blam...

Iron Man Galaxy S6 Edge Arrives With An Arc Reactor Charger

Samsung’s Iron Man-branded Galaxy S6 Edge arrives tomorrow, with a custom paint job, 64GB of on-board storage and a limited edition wireless charger accessory with an appropriate arc reactor graphic included on top. It ships with a clear cover, too, so you can protect your precious “armor” when ticketing around in the real world. The box it comes in is also red and gold, and there’s a big ol’ Iron Man helmet stencil graphic on the back of the device, too, as well as a software theme to match. I probably would’ve left off the face personally, letting the colors speak for themselves, but this was a partnership with Marvel with the intent of promoting the new Avengers film oversees, so they probably could’ve been a lot less tasteful with the branding overall. The sad news for those of you who were hoping to advertise their Stark fandom on their phones is that availability is listed as only Korea as of tomorrow, with sales beginning in China and Hong Kong...

Exciting Technology

Search This Blog