Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Mail Merge working with Excel
Hello,
I do a lot of mail merges and I want a copy of my info. from my data files to transfer into an Excel document without having to re-type all of the info into Excel. Is that possible? If so, how? -- Lisa De La Cruz, CITRMS Group Security Officer The Lionheart Group www.thelionheartgroup.com |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Mail Merge working with Excel
A bit hard to answer without knowing what your data files are like. If
you're talking about Word tables, copy and paste works well; if they text files formatted so that they work as Word mailmerge sources, Excel can open them also -- just try opening them and see what happens. "Lisa" wrote in message ... Hello, I do a lot of mail merges and I want a copy of my info. from my data files to transfer into an Excel document without having to re-type all of the info into Excel. Is that possible? If so, how? -- Lisa De La Cruz, CITRMS Group Security Officer The Lionheart Group www.thelionheartgroup.com |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Mail Merge working with Excel
Lisa
The files or Address files are kept in Access files in My Data Sources Click on the correct Address book, then right on Send To and Excel and it will create the excel spred sheet with headers and a completed list "Lisa" wrote: Hello, I do a lot of mail merges and I want a copy of my info. from my data files to transfer into an Excel document without having to re-type all of the info into Excel. Is that possible? If so, how? -- Lisa De La Cruz, CITRMS Group Security Officer The Lionheart Group www.thelionheartgroup.com |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Mail Merge working with Excel
How do you conclude that Access is the data source? It could be from any
number of other files, including the Office Address Book or even a Word doc. The OP really doesn't provide enough info for a specific solution to be offered. Hopefully Lisa will post back with more detail, as there could be a number of options to pursue. In the meantime she can pick & choose from the alternatives in Jezebel's reply as well. Regards |:) Bob Jones [MVP] Office:Mac On 11/23/06 12:29 AM, in article , "Sunday88310" wrote: Lisa The files or Address files are kept in Access files in My Data Sources Click on the correct Address book, then right on Send To and Excel and it will create the excel spred sheet with headers and a completed list "Lisa" wrote: Hello, I do a lot of mail merges and I want a copy of my info. from my data files to transfer into an Excel document without having to re-type all of the info into Excel. Is that possible? If so, how? -- Lisa De La Cruz, CITRMS Group Security Officer The Lionheart Group www.thelionheartgroup.com |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
mail merge was working until i installed kb911701.. | Mailmerge | |||
Data frm excel to word using mail merge | Mailmerge | |||
Word 2003 Mail Merge from Excel spreadsheet database | Mailmerge | |||
zip code issues when working with mail merge and excel | Mailmerge | |||
Mail Merge Issue With Office 97 - Excel Data Source | Mailmerge |