#1
|
|||
|
|||
Inputting 339 supplier names into individual Word documents
Good afternoon!
I have a questions as to whether something can be done or not. What I need to do is have a supplier name input into Word for 339 different suppliers for the same letter that is going out. I just want to be able to have the supplier names listed in Excel come over into Word and create an individual letter for each supplier without having to do all 339 myself by copying and pasting. Is this possible? |
#2
|
|||
|
|||
Use the Mail merge option in Word
Dear friend,
Try the mail merge option in Word under the Mailing tab. Create a data file in Excel with separate columns for each record. The heading row may be in bold letters. column A contains name of supplier, Column B contains first line of address, column c contains second line of address etc. Row 1 have heading, row2 will be record of first customer, row3 of second customer and so on. The file will look as below: A B C D E F name add1 add2 add2 email 1 john 87/12 Golden st London 987654 2 Tess 2nd Aenue Baker St London 32 3 Susan Watt House Kilpauk Ireland 9988 4 5 6 7 8 When you finish, you would have covered 340 rows (first row being header). Save the file. Exit Excel. Now open the Word file containing your common letter to be sent to suppliers. Select the Start Mail merge option under Tab namely Mailings. Follow the instructions. Start Mail merge --> Step by step mail merge wizard-->select document type letters, then step 1 of 6 (bottom part of the window)--> start ing document--> use current document--> select recipients--> browse--> (now select the excel file we created first,( make sure to change the file type as excel files to view our file in the open window)--> click open--> select sheet 1-->OK. Now both the files are linked. Now put the cursor in the place where you wish to have the suppliers name. Select the insert merge field option under Mailings. In the drop down menu, you will find the headings of your excel file. Select the field "name". Now bring the cursor to the place where you wish to have the add1. Repeat the earlier step. When you finish ( or even before you finish inserting the fields) you may click on the Preview Results menu under Mailing to see the merged document, with the fields of excel file inserted. Right to the Preview Results you may use the arrows to view the 2nd, 3rd and so on .. records. The mail merge is finished. Any time you can edit the Word document, which will affect all the records. Please note that you have only one Word file and one data file in Excel for all the records. So many options are available in Mail merge. If you want to edit Excel file, exit Word file, after saving , and open the excel file. Edit and close the Excel file. Then open Word file again. There are many short-cuts to save time, which you will learn in due course. Print options from record to record is available so that you can effect printing at a stretch. Sending individual letters through email also is possible. For this one field of data file in Excel should be email address. For printing as well as for sending email, you shall use the finish merge option. For email, you have to provide the header-name of relevant column where email ids of suppliers are given. For any clarification, you may send mail to me - «email address» ..Love and regards....... Pauly Sebastian Last edited by macropod; 04-29-2014 at 04:42 PM. Reason: «email address» Removed - policy violation |
#3
|
||||
|
||||
Quote:
To use this, your Excel data would need to be organised in columns, with a column for the supplier names and at least one column for each separate address line. The first row in Excel would be a header row and each subsequent row would have the supplier details. Thus, for the header row, you might have: Supplier, Address1,Address2,Locality,State,Zip It doesn't matter if some suppliers only have one address line - the blank ones can be suppressed in the mailmerge. In Word, you'd write the letter as if it were going to just one supplier. having done that, you'd use Word's mailing tools to create the mailmerge. See: http://word.mvps.org/FAQs/MailMerge/...AMailMerge.htm http://office.microsoft.com/en-au/wo...102809678.aspx http://support.microsoft.com/kb/294683/en-us
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#4
|
||||
|
||||
Quote:
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mailmerge Individual Documents | DaddyMac | Mail Merge | 4 | 06-06-2013 09:22 PM |
How to transpose the datas of part code and supplier into row and column | PRADEEPB270 | Excel | 3 | 10-26-2012 07:22 PM |
Watermark PPT prints with a series of individual names | walvis | PowerPoint | 1 | 12-16-2011 06:49 AM |
Inputting Sound files - 2 options, neither working. | msteinruck | PowerPoint | 0 | 09-16-2010 09:44 AM |
Inputting variable data | axy | Word | 0 | 09-08-2009 04:50 PM |