using autotext info for a mail merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

chuck - 25 Sep 2004 19:29 GMT

I have many addresses in my autotext file. How do I get
the addresses from autotext into Excel for a mail merge?

WIN XP pro, Gateway boxes, Word 2000 Excel 2000

Reply to this Message

Doug Robbins - 25 Sep 2004 21:18 GMT

The following macro will insert all of the autotext entries into the active
document, one to a paragraph. There will probably some that you don't need
that you will have to delete, but then you can convert that document to a
table and add a row at the top to contain a fieldname for use in mailmerge,
or copy and paste it into Excel if you want to do it that way.

Dim at As AutoTextEntry
For Each at In NormalTemplate.AutoTextEntries
ActiveDocument.Range.InsertAfter at & vbCr
Next at

Signature

Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

>I have many addresses in my autotext file. How do I get
> the addresses from autotext into Excel for a mail merge?
>
> WIN XP pro, Gateway boxes, Word 2000 Excel 2000

Reply to this Message

chuck - 26 Sep 2004 17:41 GMT

Thanks Doug,

This looks like a solution for my problem. I tried it on
my home computer and it did download all of my autotext
into a word doc. A little more manipulation and I'll have
a mail merge.

Chuck

>-----Original Message-----
>The following macro will insert all of the autotext entries into the active
[quoted text clipped - 14 lines]
>
>.

Reply to this Message