How do you mail-merge from Microsoft Word to Micro's Excel??
2007-02-06 23:35:26 · 6 answers · asked by Andy C 2 in Computers & Internet ➔ Software
there is a special software of Microsoft Office called MS Binder,
you can merge Office works, such as word, excel, powerpoint and access...
2007-02-07 00:13:47 · answer #1 · answered by aRnObIe 4 · 1⤊ 0⤋
I did this for a friend...hope it helps
A spreadsheet (in excel) or table (in word) of the contacts/ details is needed to use mail merge.
The best way to set a table out for use with mail merge is as follows. A table can be created by using the table tab in the toolbar select draw table to set how may columns etc and then click insert rows to add as many as you like.
Name 1Name 2Address 1Address 2Address3
jimbob46 mystery laneDa hoodlondonW12 000
It’s a good idea to play around with creating tables once you have created the rough set up, its really easy to make it shorter or longer etc, Not that the size of the table matters with Mail merge.
Once you have created your table, you can type the letter you want to send out. Do not insert name address etc at this stage; it is okay to use an existing document.
When the letter is complete click Tools in the tool bar at the top of the page. Depending on which version of office you are using, there may be a mail merge tab or it could be under letters and mailings. If you are using the Mail merge wizard then you want to create a Form Letter and then follow the instructions.
Once you have selected form letter there should be a tab asking you to select a data source (which is your table or spreadsheet) you wish to use an existing document so browse and open your table through my documents or where ever you have saved it.
You will then see there is a new tool bar at the top of the page of the letter you wish to use. One of the tabs should contain all the headings of your spreadsheet. E.g. name 1, name 2 and so on. Set the headings out on your letter as you want them to appear e.g.
Name 1 Name 2
Address 1
Address 2
Address 3
Address 4
Dear Name 1
Bla Blab la etc etc
Once you are happy with it, it is a good idea to print one copy at this stage if you are using a window envelope just to make sure the spacings are correct and you are happy with the layout.
Once you are happy, there should be a tab in the new merge toolbar that gives the option to merge to a new document. Select this and you should find that your letters with all the names of your intended recipients have appeared in a new document. If you are not happy you can always merge again.
It is a good idea to use excel as the data is more easily manipulated and you can store more information that you won’t use on a form letter but may use on a daily basis such as phone numbers or notes on the client etc.
2007-02-07 07:41:17 · answer #2 · answered by Anonymous · 2⤊ 0⤋
Usually it's done the other way around aint it? I've had all my address in a spreadsheet and used a mail merge to put all the addresses and salutations in a Word document, my letter. If that's what you're trying to do, the Help is usually pretty useful. If I'm not on the right lines for what you are doing, explain a bit more and I'll try to help again!
2007-02-07 07:42:28 · answer #3 · answered by Andy M Thompson 5 · 1⤊ 0⤋
The best way to do it is set up your spreadsheet columns with field description (name, address, etc) in the 1st row. Close the spreadsheet - in word go tool - letters and mailings - mail merge. There is plenty of guidance when you get to that point - use the built in help, it will answer just about any question you have from this point.
2007-02-07 07:43:53 · answer #4 · answered by whodeyflya 6 · 1⤊ 0⤋
Word to excel .. ? I think there is only cut - copy - paste is allowed between those two ..
2007-02-07 07:40:46 · answer #5 · answered by vasu_jeedigunta 1 · 0⤊ 1⤋
in word, go to tools.. compare & merge coc's..
.. it takes you through the steps..
2007-02-07 07:41:20 · answer #6 · answered by Claude 6 · 0⤊ 0⤋