How To Create A Mailing List From Excel
IS THERE A MS WORD 2003/OUTLOOK GURU OUT THERE. I need some help creating contacts?
I have a MS Excel spreadsheet with contact information of more than 4000 clients (work address, name, and job title) I add this information to a mailing label in MS Word.
Because of the size of the envelope I copy the contact information on to 4 x 3.5 mailing labels.
Recently the amount of mailing has increased; therefore I would like to know if there is a feature in MS Word were I can import this addresses from MS Excel and be able to select a random contact and have their contact information appear on the screen.
In other words, what I am trying to do is to: import a MS Excel 2003 spreadsheet in to MS Word 2003 be able select a random contact from that list, have their address appear on the screen and copy and paste the address on to a label.
I have a few other questions:
1. is this possible, if yes how can I do it
2. does MS Word 2003 has a contact information feature similar to MS Outlook, if not , can I download a template fro Microsoft.com
Click on Tools, point to Letters and Mailings and click on Mail Merge, then follow the on-screen instructions. I think this will give you more or less what you’re after. Word doesn’t have a contacts feature like Outlook, but the idea of Mail Merge is that you can use the details from Outlook or your own Excel spreadsheet.
MailPro™ – Newsletter Software – V4