Can I create lables from addresses in many letters?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SCrowley - 04 May 2005 17:06 GMT

I did a mail merge from Outlook 2003 into Word. The letters had to be
"cleaned up" is there any way I can create Labels from my cleaned up
addresses instead of re-merging into Labels and re-cleaning. Yes, the data
source will be cleaned later (corporate contacts data is dirty).

Thanks.

Signature

Thank you,
scrowley@littleonline.com

Reply to this Message

Peter Jamieson - 05 May 2005 08:46 GMT

There is no simple method but if
a. you have kept the output document
b. there is an obvious way that a piece of code could identify the address
in each letter (e.g. the address text uses a unique paragraph style, or if
the text is always the first piece of text after the first 3 empty
paragraphs in the document or some such) then you ought in theory to be able
to write a VBA macro to extract the addresses.

But that's about the best I can do...

Peter Jamieson

>I did a mail merge from Outlook 2003 into Word. The letters had to be
> "cleaned up" is there any way I can create Labels from my cleaned up
> addresses instead of re-merging into Labels and re-cleaning. Yes, the data
> source will be cleaned later (corporate contacts data is dirty).
>
> Thanks.

Reply to this Message

SCrowley - 05 May 2005 14:21 GMT

Great. Thanks. I'll try the macro method.

Signature

Thank you,
scrowley@littleonline.com

> There is no simple method but if
> a. you have kept the output document
[quoted text clipped - 13 lines]
> >
> > Thanks.

Reply to this Message