create mailmerge label from excel

[Trevor3007]

hi & good evening

unsure if this applicable to this site..but here goes.

I am needing create mail merge labels from excel, but when I insert the applicable fields into word & preview, it displays a sheet full of 1st entry. I need to have a label for each record on each sheet ( example)


current

mr smith mr smith

mr smith mr smith

mr smith mr smith​

I need :-

mr leiter mr white

mr bond dr No

mr La Chef miss lynd


hoping some kind person can give me the 'how to'

KR
Trevor3007

 

[Macropod]

Are you sure Word is set to do a label merge? Did you click on 'update labels' after setting-up the first label?

 

[Trevor3007]

thanks for your reply & help.

All sorted... thanks to you :]

KR
Trevor3007