Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Default address list for mail merge
I am using Word 2003 to do a mail merge. When I select create address list it
is saved as an Access database. How can I change the default to be an Excel file? Thanks |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Default address list for mail merge
Sorry, I don't believe that can be done *at all* let alone as the default.
My preference is to create the Excel file first, then select it as the record source for the merge. Another option: Create the list as a Word Table - Either use that as the record source or copy the table & use Edit paste Special - Text in an Excel file if you prefer. HINT: Just in case the "handy-dandy" data entry form is the reason you're trying to create the new record list from within Word's merge features - Once you type the captions in Excel leave the cell selector on the cell below your first caption, then go to Data Form in order to add/modify your list of records... it isn't exactly the same, but it makes it easier if you're not very familiar with Excel (or even if you are ) -- HTH |:) Bob Jones [MVP] Office:Mac "Brinton" wrote in message news I am using Word 2003 to do a mail merge. When I select create address list it is saved as an Access database. How can I change the default to be an Excel file? Thanks |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Default address list for mail merge
As Bob suggests, this is not possible and the file created is not a true
Access file, but an Access compatible file. Edit it in Access and you lose the original functionality. Personally if creating an address list I would use Outlook rather than Excel and for a relatively short list - maybe a hundred records or so I would use a Word table, as mail merge is particularly comfortable with a Word table. You can convert the original Access compatible data file to Word format (comma delimited) by using the edit data tool on the old MailMerge Helper which is available in all versions including the new 2007 - see http://www.gmayor.com/mail_merge_lab...th_word_xp.htm but you would then have to use the Word file as your data source, -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Brinton wrote: I am using Word 2003 to do a mail merge. When I select create address list it is saved as an Access database. How can I change the default to be an Excel file? Thanks |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Default address list for mail merge
I have a user that claims that in a previous job Word always saved her
address list to Excel when created using the data entry form. She does not like the Access database and much prefers Excel. I could not find a way to modify the default so I asked for help. I appreciate the response from both you and Bob. Thanks "Graham Mayor" wrote: As Bob suggests, this is not possible and the file created is not a true Access file, but an Access compatible file. Edit it in Access and you lose the original functionality. Personally if creating an address list I would use Outlook rather than Excel and for a relatively short list - maybe a hundred records or so I would use a Word table, as mail merge is particularly comfortable with a Word table. You can convert the original Access compatible data file to Word format (comma delimited) by using the edit data tool on the old MailMerge Helper which is available in all versions including the new 2007 - see http://www.gmayor.com/mail_merge_lab...th_word_xp.htm but you would then have to use the Word file as your data source, -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Brinton wrote: I am using Word 2003 to do a mail merge. When I select create address list it is saved as an Access database. How can I change the default to be an Excel file? Thanks |
#5
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Default address list for mail merge
In previous versions Word saved it to a Word table. As Graham said, Word is
quite comfortable with a table, and you avoid a lot of the connection and formatting problems you have with Excel, but for very long/wide databases, Excel can be more satisfactory because of its Freeze Panes capability. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Brinton" wrote in message ... I have a user that claims that in a previous job Word always saved her address list to Excel when created using the data entry form. She does not like the Access database and much prefers Excel. I could not find a way to modify the default so I asked for help. I appreciate the response from both you and Bob. Thanks "Graham Mayor" wrote: As Bob suggests, this is not possible and the file created is not a true Access file, but an Access compatible file. Edit it in Access and you lose the original functionality. Personally if creating an address list I would use Outlook rather than Excel and for a relatively short list - maybe a hundred records or so I would use a Word table, as mail merge is particularly comfortable with a Word table. You can convert the original Access compatible data file to Word format (comma delimited) by using the edit data tool on the old MailMerge Helper which is available in all versions including the new 2007 - see http://www.gmayor.com/mail_merge_lab...th_word_xp.htm but you would then have to use the Word file as your data source, -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Brinton wrote: I am using Word 2003 to do a mail merge. When I select create address list it is saved as an Access database. How can I change the default to be an Excel file? Thanks |
#6
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Default address list for mail merge
Thanks for your response.
"Suzanne S. Barnhill" wrote: In previous versions Word saved it to a Word table. As Graham said, Word is quite comfortable with a table, and you avoid a lot of the connection and formatting problems you have with Excel, but for very long/wide databases, Excel can be more satisfactory because of its Freeze Panes capability. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Brinton" wrote in message ... I have a user that claims that in a previous job Word always saved her address list to Excel when created using the data entry form. She does not like the Access database and much prefers Excel. I could not find a way to modify the default so I asked for help. I appreciate the response from both you and Bob. Thanks "Graham Mayor" wrote: As Bob suggests, this is not possible and the file created is not a true Access file, but an Access compatible file. Edit it in Access and you lose the original functionality. Personally if creating an address list I would use Outlook rather than Excel and for a relatively short list - maybe a hundred records or so I would use a Word table, as mail merge is particularly comfortable with a Word table. You can convert the original Access compatible data file to Word format (comma delimited) by using the edit data tool on the old MailMerge Helper which is available in all versions including the new 2007 - see http://www.gmayor.com/mail_merge_lab...th_word_xp.htm but you would then have to use the Word file as your data source, -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Brinton wrote: I am using Word 2003 to do a mail merge. When I select create address list it is saved as an Access database. How can I change the default to be an Excel file? Thanks |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I use same address list for mail merge and label printing | Microsoft Word Help | |||
How do I get mail merge address list into Excel spreadsheet? | Mailmerge | |||
How Produce Personal Address List for Mail Merge | Mailmerge | |||
How do I convert Word doc address list to mail merge format | Mailmerge | |||
word mail merge---address list saved as access mdb | Mailmerge |