Can anyone help with MS Word/Mail Merges?

T

tractor

Well-Known Member
Joined
18 July 2007
Messages
535
Visit site
Hi,

I'm trying to update our hunt mailing list, and get it into a workable format as opposed to using the current rubbish system (a strange Word template that you can't do anything useful with)

It seems like an Excel spreadsheet that I can use to do a mail merge onto labels is the best idea.

I have two questions:

1) Can I set up the mail merge to print onto sheets of labels? I've only ever done it to print onto a letter, and I don't remember seeing a label option....

2) I would ideally like to have one spreadsheet with separate tabs for different lists - so, I have a meet card list, subscribers, management committee and farmers - will this confuse the mail merge function? Would I be better with 4 separate spreadsheets as opposed to using tabs?

Thank you kindly for your help, and sorry if they're stupid questions!

Sarah :-)
 
Yeah you can merge to labels, it's really simple. Pretty certain Microsoft will have a cheat sheet if you google mail merge to labels (I could explain but it'll probably explain better than me!).
In answer to your second, yeah you can set them all up as different tabs and merge from them, when you choose your data source it'll give you all the tab options from that sheet.

Hope this helps :)
 
Ta muchly, will have a look at what Google throws up - just wanted to check with a real person first, sometimes Google is a bit random!

:-)
 
Yup you can, I do it all the time for work...I'm just a bit cack at explaining so would probably make it sound much worse than it is. If you have any problems with it though give me a shout :)
 
Yep, as said above - mail merge for just about anything really, inc labels.
As long as each column is defined, eg:
Title, Name, Address1, Address2, Address3, County, Postcode, Phone number etc etc, then all you need to do is select the info you want for each merge.

Agree with using seperate sheets for different things, tho you could just have the 1 & use another few columns to put in meet card list, subscriber etc too & then filter out when you want before starting the merge?

Its a pain to set up the sheets in the 1st place, but after that, it will be plain sailing, tho dont forget to periodically save to a stick or similar ;)

Hope thats understandable, if you need help, just drop a PM :)
 
You must log in or register to reply here.
Top