Tags |
|
|
Links |
|
|
Added for You - MS Word 2003 - How to Create Customized Letters with Mail Merge
As a First Time Homebuyer, you will be exposed to hundreds or thousands of ads, media stories, friends’ advice, and online mortgage calculators. All of these sources will lead you to believe that you can have a larger home loan balance with a very low payment. Or they will show you a monthly payment that seems extremely affordable for what you are looking for.The underlying tru
14) When you finish, click Next to preview your letters.
15) You can now preview your letters one at a time by clicking the Front and Back arrows in the sidebar.
16) Click Next to complete the merge and print the merged letters. At this stage you can also edit the individual letters to add your own customized flourishes and notes.
And you are done! Congrats. Now it’s time to mail them.
You can create individual labels, envelopes, directories and even e-mails following the same steps and selecting options appropriate for the kind of mail-merge you have in min
A great way to get a new home is to purchase repossessed mobile homes. But, how can you find them and are they worth the cost? In many of these vehicles, there is nothing different from them other than that their purchaser has not taken care of his finances. The bank, or lending institution is looking to get back some of their money by taking back the vehicle and trying to sell it. More than likely,
For example, you can generate a series of letters that look like these:
LETTER 1:
“B. Smith, 123 Road, Boston, MA Zip1
Dear Bob, It was great meeting you on July 23, 2005 in Cincinnati. I’d love to do business with your company Iron Works General, Inc. …”
LETTER 2:
“Coreen Brandonty, 73 Office Tower, Los Angeles, CA Zip2
Dear Coreen, It was great meeting you on February 3, 2006 in Paris. I’d love to do business with your company Tantastic Lotions, Inc. …”
Etc.
This is how you do it:
1) Fire up your Excel, create an excel spreadsheet and save it. Each variable should be a column. Read across, each RECORD will represent all the variables that you need to customize in a letter.
For example, for the above sample letters, the columns may read Name, Last Name, Street Address, City, State, Zip, Date Last met, City Last Met, Company Name, etc.
2) Switch to MS Word 2003. Create a new blank document.
3) From the main menu, select Tools > Letters and Mailings > Mail Merge to display the Mail Merge SIDEBAR on the right side of your screen. Word will automatically display the Mail Merge TOOLBAR on top of your screen.
4) Click Next to go to the next sidebar screen to start your letter.
5) Select the “Use Current Document” radio button.
6) Click Next to go to the next sidebar screen and select your “recipient database.”
7) Click BROWSE in the sidebar to find the Excel sheet.
8) Click Open. Click through the prompt windows to select the appropriate table(s) and variables. Your spreadsheet should now be listed in the sidebar under the “Use an existing list” section.
9) Click on “Edit Recipient List” and then click OK in the “Merge Mail Recipients” dialog box.
10) Click Next to go to the next sidebar screen to start WRITING your letter.
11) Start typing your letter on the blank page. When you come to a VARIABLE that should change from one recipient to another, click More Items in the sidebar to display the Insert Merge Field dialog box.
12) Select the variable that you’d like to insert into your letter and it will appear as a place holder in between a pair of double-chevrons, depending on the way you have named your columns in the Excel spreadsheet.
13) Repeat Step 13 as many times as necessary as you type your letter.
14) When you finish, click Next to preview your letters.
15) You can now preview your letters one at a time by clicking the Front and Back arrows in the sidebar.
16) Click Next to complete the merge and print the merged letters. At this stage you can also edit the individual letters to add your own customized flourishes and notes.
And you are done! Congrats. Now it’s time to mail them.
You can create individual labels, envelopes, directories and even e-mails following the same steps and selecting options appropriate for the kind of mail-merge you have in mind
ProblemsIn many ways, the requests for technical assistance are symptomatic of the deficiencies in the users' training or the quality of the documentation they were given. Of course, the users have to read the training material; understandably, the reading can be monotonous. However, producing step-by-step videos for the purpose of instructing does not make economic sense. This i
Etc.
This is how you do it:
1) Fire up your Excel, create an excel spreadsheet and save it. Each variable should be a column. Read across, each RECORD will represent all the variables that you need to customize in a letter.
For example, for the above sample letters, the columns may read Name, Last Name, Street Address, City, State, Zip, Date Last met, City Last Met, Company Name, etc.
2) Switch to MS Word 2003. Create a new blank document.
3) From the main menu, select Tools > Letters and Mailings > Mail Merge to display the Mail Merge SIDEBAR on the right side of your screen. Word will automatically display the Mail Merge TOOLBAR on top of your screen.
4) Click Next to go to the next sidebar screen to start your letter.
5) Select the “Use Current Document” radio button.
6) Click Next to go to the next sidebar screen and select your “recipient database.”
7) Click BROWSE in the sidebar to find the Excel sheet.
8) Click Open. Click through the prompt windows to select the appropriate table(s) and variables. Your spreadsheet should now be listed in the sidebar under the “Use an existing list” section.
9) Click on “Edit Recipient List” and then click OK in the “Merge Mail Recipients” dialog box.
10) Click Next to go to the next sidebar screen to start WRITING your letter.
11) Start typing your letter on the blank page. When you come to a VARIABLE that should change from one recipient to another, click More Items in the sidebar to display the Insert Merge Field dialog box.
12) Select the variable that you’d like to insert into your letter and it will appear as a place holder in between a pair of double-chevrons, depending on the way you have named your columns in the Excel spreadsheet.
13) Repeat Step 13 as many times as necessary as you type your letter.
14) When you finish, click Next to preview your letters.
15) You can now preview your letters one at a time by clicking the Front and Back arrows in the sidebar.
16) Click Next to complete the merge and print the merged letters. At this stage you can also edit the individual letters to add your own customized flourishes and notes.
And you are done! Congrats. Now it’s time to mail them.
You can create individual labels, envelopes, directories and even e-mails following the same steps and selecting options appropriate for the kind of mail-merge you have in min
Date stamp equipment is now considered to be part and parcel of most organizations and companies. The date stamp equipment provides vital information to the organization on when any document or paper was received by the company or processed and forwarded by the company.With the date stamp equipment, one can automatically imprint the date onto a document. The operation of the equipment is rather e
4) Click Next to go to the next sidebar screen to start your letter.
5) Select the “Use Current Document” radio button.
6) Click Next to go to the next sidebar screen and select your “recipient database.”
7) Click BROWSE in the sidebar to find the Excel sheet.
8) Click Open. Click through the prompt windows to select the appropriate table(s) and variables. Your spreadsheet should now be listed in the sidebar under the “Use an existing list” section.
9) Click on “Edit Recipient List” and then click OK in the “Merge Mail Recipients” dialog box.
10) Click Next to go to the next sidebar screen to start WRITING your letter.
11) Start typing your letter on the blank page. When you come to a VARIABLE that should change from one recipient to another, click More Items in the sidebar to display the Insert Merge Field dialog box.
12) Select the variable that you’d like to insert into your letter and it will appear as a place holder in between a pair of double-chevrons, depending on the way you have named your columns in the Excel spreadsheet.
13) Repeat Step 13 as many times as necessary as you type your letter.
14) When you finish, click Next to preview your letters.
15) You can now preview your letters one at a time by clicking the Front and Back arrows in the sidebar.
16) Click Next to complete the merge and print the merged letters. At this stage you can also edit the individual letters to add your own customized flourishes and notes.
And you are done! Congrats. Now it’s time to mail them.
You can create individual labels, envelopes, directories and even e-mails following the same steps and selecting options appropriate for the kind of mail-merge you have in min
So, you have decided to start investing in real estate and you are wondering whether to flip properties. Maybe you've attended a real estate investment seminar and pre-seminar on flipping properties. Maybe you've seen a television program about how easy it is for people to make $30,000 or more flipping properties. Maybe you saw an article in your newspaper about the flipping property craze.Well,
10) Click Next to go to the next sidebar screen to start WRITING your letter.
11) Start typing your letter on the blank page. When you come to a VARIABLE that should change from one recipient to another, click More Items in the sidebar to display the Insert Merge Field dialog box.
12) Select the variable that you’d like to insert into your letter and it will appear as a place holder in between a pair of double-chevrons, depending on the way you have named your columns in the Excel spreadsheet.
13) Repeat Step 13 as many times as necessary as you type your letter.
14) When you finish, click Next to preview your letters.
15) You can now preview your letters one at a time by clicking the Front and Back arrows in the sidebar.
16) Click Next to complete the merge and print the merged letters. At this stage you can also edit the individual letters to add your own customized flourishes and notes.
And you are done! Congrats. Now it’s time to mail them.
You can create individual labels, envelopes, directories and even e-mails following the same steps and selecting options appropriate for the kind of mail-merge you have in min
IntroductionPlanning for retirement is serious business. If you are in the process of developing a retirement plan, you have to take into consideration the debt that you have today. The debt you have today has a direct impact on your ability to plan for an investment in your retirement. In short, it is important for you to get your debt under control in advance of really sitting down and devel
14) When you finish, click Next to preview your letters.
15) You can now preview your letters one at a time by clicking the Front and Back arrows in the sidebar.
16) Click Next to complete the merge and print the merged letters. At this stage you can also edit the individual letters to add your own customized flourishes and notes.
And you are done! Congrats. Now it’s time to mail them.
You can create individual labels, envelopes, directories and even e-mails following the same steps and selecting options appropriate for the kind of mail-merge you have in mind.
This is one well-tested and bug-free MS Word feature that in my judgment beats OpenOffice’s mailmerge functionality which crashes often.
HTTP = HTML link (for blogs, profiles,phorums):
<a href="http://www.added4u.com/article/164731/added4u-MS-Word-2003--How-to-Create-Customized-Letters-with-Mail-Merge.html">MS Word 2003 - How to Create Customized Letters with Mail Merge</a>
BB link (for phorums):
[url=http://www.added4u.com/article/164731/added4u-MS-Word-2003--How-to-Create-Customized-Letters-with-Mail-Merge.html]MS Word 2003 - How to Create Customized Letters with Mail Merge[/url]
Related Articles:
Ready Advice On Debt Consolidation
Can Online Auto Insurance Save You Money?
Bookmark it:
|