How to Fill the Labels in Mailling Label.

T

Thiru

Hi,

i am using following code to fill the Conatct deatils in the

Labeles.

addr = "Dave Edson" & vbCr & "123 Skye St." _
& vbCr & "Our Town, WA 98004"
Application.MailingLabel.CreateNewDocument _
Name:="2160 mini", Address:=addr, ExtractAddress:=False


But it places Same Addrerss Details in all the Labels of the
Document.

But i have a set of Contact Details, Each Contact Details should go

to each Label.I really do not know how to Pass the Different contct

details...to each Label.

Can any one help me to do this.

Thanks in Advance,
Thiru
 
G

Graham Mayor

You seem to be on a wheel re-invention exercise here. What is wrong with
mail merge?

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
T

Thiru

Hi,

The code which i posted does the following things.

I(t Open the New Documents and Creates the Specified label and Fills the
same Data in all the labels.

But i want to fill different data in Each label.
Could you tell me how to do that...

Thanks in Advance..
Thiru.
 
Top