You can use your favorite social network to register or link an existing account:
Or use your email address to register without a social network:
Sign in with these social networks:
Or enter your username and password
Forgot your password?
Yes, please link my existing account with for quick, secure access.
No, I would like to create a new account with my profile information.
We know that lots of you are interested in doing mail merge (i.e., transferring a contact list in Outlook to a sheet of labels in Word) quickly and efficiently. But we'd love to know more about what you're using mail merge for (business mailings? personal stuff like holiday cards?) and what programs you use for mail merge.
We'll use what you tell us to make videos about the best ways to use mail merge. So please take a second, and answer this brief poll. Even better, leave a comment describing what you use mail merge for, or some brilliant way you've discovered that makes it super easy, and/or what you wish were better. We appreciate the help, and we'll use it to help you!
Update: We've now closed the poll, but thanks to all of you who voted! The winner was "Send emails to customers," followed closely by "Newsletters." "Sweepstakes entries" was kind of a joke, but it still got 13 votes....
Comments: (10) Collapse
Office just keeps getting better and better!
Ms. office really helped me in a job as a writer and editor.
I am executive secretary of my Rotary club and produce the bulletins (a combination of program and newsletter) that are distributed at our weekly meetings. After each meeting I use mail merge in Word 2003 to address bulletins to members who missed the meeting. I love being able to just check off the absentees in the Mail Merge Recipients dialog (which I maximize for greater efficiency). Once a month or so I use mail merge to address envelopes to mail the Club Service assignments to the Rotarians who are assigned to certain meeting tasks (Greeter, Fund Raiser, Speaker Host) for the next month. At other times I address envelopes to mail memos to members of our orientation classes or other small groups. Sometimes I am asked to produce labels for mailing event invitations to all club members.
I also create mail merges (labels, letters, envelopes) for clients as required.
I extract an employee list (number, initial, surname, department, type) from our payroll package into excel. I then do labels in word, which also have the dates of the week to be worked and the date it will be paid. Print onto Avery labels and stick them on the cards :-)
Sounds long winded, but I can't get the result I need from the payroll package, and it'd take me longer to write by hand (and they'd be illegible)
I need to do a simple set of lables from mail merge in Office 2010 which was easy in earlier versions of word but I dont use lables from your list of suppliers - and I cannot get the program to accept the label size details that I have typed in - please help
HI Alex, I would try selecting Microsoft as your label vendor, finding an option that looks close to your size, and then hitting the "new label" button at the bottom of the "Label Options" dialogue box. That menu allows you to specify your sizes quite closely. Do let me know if that works for you.
I want to be able to see the faded gridlines when typing labels without the
gridlines being printed in word /office 10 does anyone know how to do this
I was thinking of using mail merge to help me convert show leads sent in an unmanageable Excel spreadsheet (one example contains 39 individual leads with 30 columns - most not necessary for the follow-up) in to a lead form created using Word 2002. I was able to create the mail merge template and if I wanted to I could print off all 39 of the leads with the contact information prefilled. What I would like to do however is save all 39 pages as a document that I can then separate and email to the appropriate salesman that needs to follow up on the leads. They have to fill in a section on the lead form with follow up information.
HI Mo, I'm afraid we don't know of a simple way to do what you're describing with mail merge. It might be simpler to break up your Word doc manually and send them out to the relevant salespeople. I'd encourage you to post your question to answers.microsoft.com/.../default.aspx the forums might put you onto a third-party program that could solve this for you.
Thanks Doug Kim. I was hoping to avoid that because I have about 150 leads I have to do that to. I guess I will be busy for a while.
Comments: (loading) Collapse