A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Can I create lables from addresses in many letters?



 
 
Thread Tools Display Modes
  #1  
Old May 4th, 2005, 05:06 PM
SCrowley
external usenet poster
 
Posts: n/a
Default Can I create lables from addresses in many letters?

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.
--
Thank you,

  #2  
Old May 5th, 2005, 08:46 AM
Peter Jamieson
external usenet poster
 
Posts: n/a
Default

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
"SCrowley" wrote in message
...
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.
--
Thank you,



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Create Table Primary Key after Make Table Query And Update Table RNUSZ@OKDPS Running & Setting Up Queries 1 May 3rd, 2005 08:07 PM
Sending Mail Merge to Email to Multiple Recipients in the Same Mes Mark V Mailmerge 11 December 20th, 2004 10:58 PM
Outlook 2003, Cannot Import or Export E-mail Addresses Paul Bomboy General Discussions 0 December 15th, 2004 05:23 PM
create and print labels for multiple addresses Omyomi New Users 1 December 12th, 2004 12:52 AM
Extract email addresses from the pst file and create it as a contact. monkeyjob Contacts 0 June 24th, 2004 03:57 PM


All times are GMT +1. The time now is 02:42 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.