Home |
Search |
Today's Posts |
#1
|
|||
|
|||
set up a data base in word or excel?
I am trying to set up a data base of names for a mailing list, and then make
it retrievable into a letter format or just envelope addressing. Anyone with information on how to help me would be greatly appreciated. It has been years since my college days and learning macros and such. |
#2
|
|||
|
|||
set up a data base in word or excel?
No macros necessary. Use Excel to store the data: Row 1 is column headings,
row 2 your first record (address), row 3 your second record, etc. Save it, close it. Open Word, do a mail merge. http://www.officearticles.com/word/m...osoft_word.htm ************ Anne Troy www.OfficeArticles.com "workingwoods" wrote in message ... I am trying to set up a data base of names for a mailing list, and then make it retrievable into a letter format or just envelope addressing. Anyone with information on how to help me would be greatly appreciated. It has been years since my college days and learning macros and such. |
#3
|
|||
|
|||
set up a data base in word or excel?
Hello-
IMHO, you'll be far better off to store your list of records in an XL file & use Word for the docs to merger the record data into. See: http://sbarnhill.mvps.org/WordFAQs/E...MailMerges.htm for some good, clear advice. HTH |:) "workingwoods" wrote: I am trying to set up a data base of names for a mailing list, and then make it retrievable into a letter format or just envelope addressing. Anyone with information on how to help me would be greatly appreciated. It has been years since my college days and learning macros and such. |
#4
|
|||
|
|||
set up a data base in word or excel?
See http://word.mvps.org/FAQs/MailMerge/...AMailMerge.htm and
http://word.mvps.org/FAQs/MailMerge/...DataSource.htm. -- Charles Kenyon Word New User FAQ & Web Directory: http://addbalance.com/word Intermediate User's Guide to Microsoft Word (supplemented version of Microsoft's Legal Users' Guide) http://addbalance.com/usersguide See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome! --------- --------- --------- --------- --------- --------- This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn from my ignorance and your wisdom. "workingwoods" wrote in message ... I am trying to set up a data base of names for a mailing list, and then make it retrievable into a letter format or just envelope addressing. Anyone with information on how to help me would be greatly appreciated. It has been years since my college days and learning macros and such. |
#5
|
|||
|
|||
set up a data base in word or excel?
No-one has mentioned Outlook which is the obvious place to store addresses
http://www.gmayor.com/mailmerge_from_outlook.htm That aside, Word can use a variety of data formats, but the most reliable is to use a Word table. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org workingwoods wrote: I am trying to set up a data base of names for a mailing list, and then make it retrievable into a letter format or just envelope addressing. Anyone with information on how to help me would be greatly appreciated. It has been years since my college days and learning macros and such. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
take yet another lesson from wordperfect "reveal codes" | Microsoft Word Help | |||
how do i set up template in vbeditor without proggramming language | New Users | |||
Copying Excel data into Word: setting the Tabs | Page Layout | |||
creating forms | Microsoft Word Help | |||
Specific Email Merge w/ Specific Attachements | Mailmerge |