ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Importing a Word merge directory into Excel (https://www.excelbanter.com/excel-discussion-misc-queries/137415-importing-word-merge-directory-into-excel.html)

lgpars

Importing a Word merge directory into Excel
 
Does anyone know if it is possible to import a data directory that was
created in Word for a merge into Excel as an address list? If so, could you
explain how to do this. Thank you.

Anne Troy[_2_]

Importing a Word merge directory into Excel
 
This is the only thing of which I'm aware that even comes close:
http://www.gmayor.com/convert_labels...mail_merge.htm
However, depending on the layout of your data, you might try copy/paste.
Here's a few tips (see "Vertical to Horizontal addresses")
http://www.officearticles.com/excel/...soft_excel.htm
****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************
"lgpars" wrote in message
...
Does anyone know if it is possible to import a data directory that was
created in Word for a merge into Excel as an address list? If so, could
you
explain how to do this. Thank you.




lgpars

Importing a Word merge directory into Excel
 
Thanks, Anne, but that is too confusing for my finite brain. Ha! I guess
I'll just leave it in a mail merge directory in Word. We were sending these
files to a printer so hopefully he can work with the Word directory to put
the addresses on the brochures. I'll let him worry about it anyway. Thanks
for your help though.

Linda

"Anne Troy" wrote:

This is the only thing of which I'm aware that even comes close:
http://www.gmayor.com/convert_labels...mail_merge.htm
However, depending on the layout of your data, you might try copy/paste.
Here's a few tips (see "Vertical to Horizontal addresses")
http://www.officearticles.com/excel/...soft_excel.htm
****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************
"lgpars" wrote in message
...
Does anyone know if it is possible to import a data directory that was
created in Word for a merge into Excel as an address list? If so, could
you
explain how to do this. Thank you.






All times are GMT +1. The time now is 10:24 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com