Each year I have to do a large mailmerge, and each year I forget how to do it. I have watched many other videos, and none of them are as clear and broad as yours. I search out your video every year and everything works beautifully as a result. Thank you. You deserve a good pat on the back.
@amyhuckaby2164
9 ай бұрын
Every year, you save my bacon! Thank you once again!
@stopdrinkingleftskoolaid6510
3 жыл бұрын
I just printed 746 labels and I wish I had seen this video earlier. I didn’t know about using the edit option instead of the “print” option. Great job explaining all this.
@mhharley
3 жыл бұрын
This was so helpful. I used to mail merges all the time. Something changed in how to do them. I was getting very frustrated and decided to look up how to do them. Thanks for the great tutorial.
@Reiner-be5lt
2 жыл бұрын
So many videos on this topic. Finally, one that worked for me. It shouldn't be so hard!
@kristennorth3006
3 жыл бұрын
I am so grateful to you right now! You don't even know how relieved I am to finally stop randomly clicking on things. Thank you, good sir. I'm am emailing this link to myself so that I can watch it again when it's time to do it next month.
@SixMinutesSmarter
3 жыл бұрын
You are so welcome! The mailing labels merge is usually one of those skills the folks only need 1-2 times per year.
@ericasampo6950
2 жыл бұрын
Thank you! You saved my bacon on my sons graduation announcements! My version of Word was slightly different but I figured it out based on your directions. So thankful!!
@heathersuggs6015
2 жыл бұрын
Thank you sooooooooo much!!! Your video is easy to understand and you talk slowly and distinctly. I watched other videos, but they talked too fast and didn't do some of the short cuts you do. I thank God for you, Ralph!!!
@jennifercarter3346
4 жыл бұрын
This tutorial is incredibly useful! It made the process of addressing holiday cards far less painful.
@dawnjohnson1148
4 жыл бұрын
This saved me hours of work - 1200 labels! You made it so simple. Thank you.
@suzanneread7326
4 жыл бұрын
Ralph, Thank you very much for your time in creating this video, I made 316 labels in 5 min and did not use mail merge in about 15 years so thank you again. Good day :)
@alanwall6794
2 жыл бұрын
I have this video saved and every time I send out birthday cards(monthly), I replay it. So incredibly useful, thank you.
@markpriest8863
Жыл бұрын
I've never taken any microsoft classes, it's all been OTJ. Love the video, it was Incredibly helpful and easy to follow.
@tamitam8
5 жыл бұрын
This was so helpful and straightforward. Thank you for taking the time to share. Helped a ton with my holiday cards! :-)
@ksmith53
4 жыл бұрын
Incredibly helpful and easy to follow. Thank you for being so clear and concise! One note for other users - mail merge doesn't seem to handle the new 5+4 zip codes yet.
@clarestokolosa
3 жыл бұрын
This was excellent and believe me I was watching videos on this all morning. The finish merge was the missing step for me. I was only get the first page or labels to print before I did this step.
@Dougohere1
2 жыл бұрын
You made creating labels from my Excel spreadsheet an enjoyable task. Thank you for your clear and concise tutorial.
@sandyparker2564
3 жыл бұрын
Ralph. You’re the man!! I have been trying to do this for my Christmas labels for years but never had the time to figure it out. “Luckily” COVID-19 has given me LOTS of free time. Thank you for making a clear and concise video making this process so easy!!!!
@marieyoungbr
2 жыл бұрын
This is terrific. We struggled and then found your video. It's perfect -- thank you!
@rayaldridge2506
5 жыл бұрын
Raph, This updated Mail Merge video was very helpful. Thank you.
@jessicahuber5543
3 жыл бұрын
My first KZitem comment ever but I just had to say thank you! One of the best help videos I have ever watched. Super simple and straightforward. Hadn't done a mail merge in forever so I was missing a few steps. Thanks for filling in the blanks!
@SixMinutesSmarter
3 жыл бұрын
Glad it helped!
@postalgreetingcards
5 жыл бұрын
BEST video on this subject.....now the geezer may be able print labels. I seem to always have an issue with each label running down slightly in to the next label. Will try this.
@debbiesarna9940
3 жыл бұрын
Very helpful for a "not so young" lady. Thank you Thank you. Easy to understand!
@amyhuckaby2164
5 жыл бұрын
You have saved my brain once again. Thank you so much for this!! Perfect.
@andyhicks3472
5 жыл бұрын
Ralph, thank you so much! This is exactly what I was looking for. Your directions are so clear. Kudos!
@francislumley7773
5 жыл бұрын
Thank you Ralph! Very helpful video, got my labels done in no time 👍👍👍👍👍
@SWChris
4 жыл бұрын
EXACTLY what I was looking for, right down to the template. Thanks!
@willbadra4247
3 жыл бұрын
Wow, you have blessed communication skills. Thank you!
@CarolynStrong
4 жыл бұрын
Nicely done. Very easy to follow!
@lesakat
5 жыл бұрын
EXACTLY what I was looking for. Perfect! Thank you!
@lucindakamradt4909
2 жыл бұрын
Just what I was looking for. Quick and easy steps to follow. Thank you.
@estjunk
4 жыл бұрын
Hi Ralph! Thank you so much! I work for a church that often does mailings and couldn't figure out how to add and delete address' from my mailing list which is on an excel doc. You just saved me from hours of work! ty ty ty!
@SixMinutesSmarter
4 жыл бұрын
I’m happy it all worked out. Thanks for watching.
@kaydenealmquist1347
3 жыл бұрын
Thanks so much - very easy to follow. Made my Christmas labels for friends and family.
@aprilwoodis6260
3 жыл бұрын
Fantastic! Easy to follow. Thank you.
@russmiller8069
4 жыл бұрын
Boy your video is so much better than the help videos from Microsoft.
@rickdorman9420
2 жыл бұрын
Thank you so much! It was very detailed and just what I needed!!
@mikenco
2 жыл бұрын
Perfect tutorial for this topic.
@gregparsons2714
4 жыл бұрын
Very helpful. Thanks for being complete (others don't know about how to print ALL pages, how to use it again next time, etc.
@pattymanuel999
3 жыл бұрын
This was very helpful and informative! Thank you!
@suzannejarvis9114
3 жыл бұрын
So easy to follow! Thank you!
@user-pg5ry1oj6z
10 ай бұрын
Easy to follow, thank you so much!
@brianmlogan5971
4 жыл бұрын
This was fantastic! Saved me a bunch of time! THANK YOU !!
@McFly767
3 жыл бұрын
Outstanding tutorial. Step by step, concise, just what I needed. Thank you.
@brettd8566
4 жыл бұрын
Great work! Very simple to follow along.
@jeannasawicki8561
Жыл бұрын
This was so very helpful, thank you!
@Junjo11
Жыл бұрын
Very good instructions. Thank you
@dannainan
3 жыл бұрын
This is so helpful, thank you so much!!!
@kathypearson8485
3 жыл бұрын
soooo good thank you thank you thank you!! You saved my bum today!!!
@laurenbrown4509
3 жыл бұрын
This was VERY helpful. Thanks.
@saallday294
4 жыл бұрын
Thank you! This was so helpful!!!
@vivianm8174
2 жыл бұрын
Great tutorial! Thank you!
@alejandraromero9476
4 жыл бұрын
RALPH YOU ARE FANTASTIC THANK YOU SO MUCH FOR SHARING THIS INFORMATION WITH US!!!!=)
@samuelcollie2050
4 жыл бұрын
Thank you. I had to have a reminder!
@gulllali249
3 жыл бұрын
Thank you so much Ralph Phillips
@richardcandia-realestatean3543
3 жыл бұрын
So clutch....Thank you for sharing
@matthewcolosus
3 жыл бұрын
Excellent tutorial - thank you.
@theodoraaugusta6454
3 жыл бұрын
10/10 explanation
@ricky99la
4 жыл бұрын
Very Helpful Thanks!
@wingnut29
4 жыл бұрын
Ralph Great Video! #Question: I have an Address2 field with Apartment number, example "Apt 401", but not all Address2 fields have data, several are blank. How do I setup the merge in such away that I don't get a blank line on the labels where Address2 is empty? Is there some time of IF or something to skip the blank line?
@patp4789
Жыл бұрын
There are some changes to the more recent Word program, but this still was a life-saver. Thank you! (Any updates?)
@karenhanberg301
4 жыл бұрын
Thank you for your easy to follow tutorial. I created the mailing labels and they look on my computer just like yours, centered on the label. However, when I print a test page, the address label information is left hand aligned. How can I fix this problem?
@rayaldridge2506
5 жыл бұрын
Ralph, Can you Filter records in Excel and use those filtered records to Mail Merge Labels in Word or do you have to do the filtering in Word when you create the mailing labels? I have not been able to find the answer to this question.
@americanadian2
5 жыл бұрын
I would filter the records in Excel, then copy the filtered results into a separate Excel Sheet (a new tab in the same Excel document). Then when using Mail Merge in Word, select the newly created Excel Sheet as the source to pull the data from. Hope that helps!
@deel.pearson4542
4 жыл бұрын
Hey Mr. Ralph, once you’re on the Word document 1st box. Creating your label before you update the others. I would like to center my information for each label. Using the entire label, eliminating any margin adjustments. Is this correct or is there an easier way? Please email your answer or solution.
@robertrosero5444
2 жыл бұрын
Great, Thanks
@fereydoonkarami4049
4 жыл бұрын
oky was very good training
@md.saifulislamtuku9303
5 жыл бұрын
Sir, I think I created a document and gave it to one person that he would not be able to do that document after a given date or time. If the system of such lock can be done in "XL". If it is, then it will be beneficial if you create a tutorial on that topic. Thank you
@nataliep83
3 жыл бұрын
Thank you!!
@laurabraverman107
3 жыл бұрын
THANK YOU!!!!!
Ай бұрын
Do you happen to know how you can start in the middle of a label sheet to print lets say only 5 or 6 labels starting in the middle of the sheet instead of at the top? I have hundreds of used Label Sheets and have not figured that one out yet. Please help. LOl!
@johnwaymann1264
3 жыл бұрын
Good morning Ralph, Thanks for the tutorial. Question: lets say Bob Smith and Sally Jones live at the same address. How would you set up a "conditional" field for the occasional label that has "2 names". Any thoughts or recommendations? Thanks Ralph.
@SixMinutesSmarter
3 жыл бұрын
Good question, John. Sorry, but no slick/automated answer for you. I would do my work in the Excel/dataset, NOT in Word. There are a couple of situations that could cause grief... - two people at the same household that have different surnames (as you pointed out) - two people at the same household that have the same surname - three or more people at the same household (adult children, roommates, etc.) The things I would try include... - sort the addresses by zip code and address (in case there is a similar address in a different town) - use conditional formatting to highlight duplicates - create a new column for label name. This would be a concatenation (concat function) of the first and last names for most people. However, I would occasionally make a group name: Smith Household, Lisa Walker & Thom Jones, Barry & Belinda Carlisle, etc. Note, I would only join names in these traditional methods if I know the people involved. - Now that you have a new label name column, delete records/rows from the dataset so that the same household doesn't get duplicate mailings. - Run the mail merge using the label name field as the name. Because this requires so much scrutiny and manual editing, I'd only do this for personal mailing list. If I was a business and there were thousands of recipients, I would go with the risk of multiple mailings to the same address or just delete duplicate addresses knowing that only one person in the household would get the mailing. For instance, all REI catalogs we get mailed to my house are in my wife's name, although I've got the REI account and do most of the shopping there.
@greenearthblueskies8556
2 жыл бұрын
THANKS SO MUCH...
@galinapalis2765
5 жыл бұрын
God bless you
@strategywizard
4 жыл бұрын
How do you perform this same merge if you have multiple Excel worksheets?
@heatherbrown7299
2 жыл бұрын
Omg thank you
@todaysproducts3681
3 жыл бұрын
it any i can print directly to the mailing pieces instead use label.because use label take to much time to peel the sticker and label. i have to many poster to mail out.
@SixMinutesSmarter
3 жыл бұрын
It is possible to print directly to envelopes or to folded brochures. I haven’t printed to envelopes in years and can’t test. Most big office printers have an envelope feed, but it takes more care and planning because misprints can make things look sloppy. Printing to brochures is more straightforward and you’d use mail merge to individual documents/letters instead of labels.
@Drummachine22
4 жыл бұрын
Even after following these steps, the previews are blank and they do not show up on the page. Thoughts on what I'm doing wrong?
@SixMinutesSmarter
4 жыл бұрын
1. Double-check your excel data and make the sure table is unbroken--there should be no empty columns and no empty rows. I've seen some folks create a table header row and then a blank row, and then the table of data. They might even hide that empty row so it's not seen. Check the row numbers and the column letters in Excel. 2. Before doing your first preview, you're designing just one label in the top-left corner. You should be able to select the fields from the drop-down in word. If the excel is properly connected to word, you'll see your table header cells as the drop-down choices in word.
@organicremedy357
3 жыл бұрын
I bought Uline labels. Uline is not a listed vendor in the Word labels vendor list. Uline provides a Word template but I cannot get it to work.
@SixMinutesSmarter
3 жыл бұрын
Hi, Organic. That's tough, but there's still some potential. Try to find the Avery equivalent of the Uline labels. Use the label dimensions and the # of labels per sheet to help. So, I hunted around at www.uline.com/BL_1230/Uline-White-Laser-Labels and found that the Uline S-5042 seems the same as the Avery 5160. That's 30 labels per sheet and each label is 1 inch X 2 5/8 inches. That may be enough, but test first. Print only your first sheet of labels on plain paper. Then, I seriously have done this, hold your Uline label sheet above your test print sheet in front of a light and see if the labels look like they're going to print lined up right. If so, you're set. If not... You'll need to make fine adjustments to the table layout that makes up the label sheet template. Click the little selector handle in the top-left corner in Word and turn all of the labels on. Then make fine adjustments where needed to match the template to your Uline sheet. Good luck.
@organicremedy357
3 жыл бұрын
@@SixMinutesSmarter thank you very much!!
@jamesbarrie9111
4 жыл бұрын
nope doesn't work is this on a PC or Mac? what version are you using? uggggg
Пікірлер: 88