Excellent series of videos and demonstrations, thank you.
@CHENHAREL5212 күн бұрын
Huge thanks! It saved me so much time. Excellent video and explains in a simple way, thank you!!
@giftynyahe6880Ай бұрын
Great tutorial
@BridgetteLemon-v8uАй бұрын
Very thorough and helpful - thank you :)
@user-ok7rg8bl2eАй бұрын
Standing Ovation over here. Thank you thank you thank you.....
@jjuukowilliamgeorge679Ай бұрын
I just like this old man"Rich" keep it up
@IzaanshakkirАй бұрын
I was now fully clear with mail merge thanks for your help☺
@KlutseHildaАй бұрын
This is really simple. Thank you for the tutorial
@MungunguAnnely-eh6ue2 ай бұрын
❤❤❤❤❤ CT
@milenadoncev3 ай бұрын
Tnx a lot!
@priyalemon19443 ай бұрын
I watched a lot of videos on Mail Merge and this one is definitely the best and easiest to follow. Thank you.
@techhelptoday2743 ай бұрын
Thank you so much for the kind words. Glad it was helpful!
@LucretiaVanPelt4 ай бұрын
Thank you, kindly!
@techhelptoday2744 ай бұрын
You're very welcome!
@siraries13194 ай бұрын
Custom Animations and Timing in Microsoft Powerpoint Presentation - Empowerment Technology - Grade11 kzfaq.info/get/bejne/jrRjeKt6r6-0aHk.html Mail Merge Custom Animations and Timing in Microsoft Word - Empowerment Technology - Grade11 kzfaq.info/get/bejne/jrRjeKt6r6-0aHk.html
@hezbonongeri-qe1jj4 ай бұрын
this was good Mr.
@user-dp6vr3yx2y5 ай бұрын
thanks teacher
@user-ny2tv2uq4c5 ай бұрын
So helpful! And it works! Thank you.
@techhelptoday2744 ай бұрын
Great to hear!
@judithroom36565 ай бұрын
Hi are you able to add in the mail merge code for a date that is in the UK format eg day/ month/ year not month/ day/ year? Thank you
@kanishkap33265 ай бұрын
Thank you this video helped me a lot
@user-vj4bd9br3x6 ай бұрын
Thanks for the tutorial. A very simple step by step procedure. Easy to understand.
@user-lw1so1sw7w6 ай бұрын
Option 3 did NOT work for me. I will try and see if there's a Power Automate version of Microsoft Word print to do this in 365. When you do Power Automate for E-Mails it doesn't seem to have trouble transferring over the $amount. Gosh, this is difficult!!!!
@pashayevagunay66638 ай бұрын
I need support. I need the number format as #.0,00 as per Italy and Netherlands regulations. The format is correct in excel but when I do mail merge it disappears. I need support
@brendachin66648 ай бұрын
Very helpful, well done
@user-ij5yn4jl2v8 ай бұрын
I've just put a $ sign in front of the first bracket { and it worked. Then a % sign in front of the last bracket where I wanted a percentage figure, also worked.
@vasilisa61289 ай бұрын
Thank you so much, Rich! In just 2.5 minutes you solved my problem that had been going on for many years! It helped! I couldn't fight this number format errors before, finally for a long time I saved it as text, but I haven't used TEXT function with format option! Thank you!
@techhelptoday2748 ай бұрын
Glad it helped! Thanks for your feedback.
@iolanisjourney48289 ай бұрын
Most straightforward and helpful tutorial ever!!!! THANK YOU 😊
@techhelptoday2749 ай бұрын
Thank you for the kind words. I hope you found the information useful.
@vickylam58469 ай бұрын
I can find the excel file for mail merge above hyperlink provided? where is it? thanks
@vickylam58469 ай бұрын
sorry for my typo, I mean can't find the excel indeed.
@vickylam58469 ай бұрын
Thanks for your video which is very good indeed. 1 question is that should I define the Title, First name in the "more items" icon or in the Inseret Merge field where I can see same information available, what is the different? thanks. 👍👍
@audreytania82409 ай бұрын
Awesome!! Option no. 3 works for me. Thank you so much 🎉 ..and I subscribed! 😊
@bucknips10 ай бұрын
Thank you, Thank you!!!! You are a very good teacher!
@user-np5vf4ei3e10 ай бұрын
This was the best help I found for currency and date, Thank you!
@amyluckenbill551511 ай бұрын
Yes. Hands down, the best tutorial. Quick fix using picture switch. Thank you for the lesson!!
@mohammedziyad1381 Жыл бұрын
Thank you for the nice lesson ❤
@ferryboma Жыл бұрын
its easier to use codes, i think
@merbella4201 Жыл бұрын
very helpful video - solved my issue with mail erge and figures with excesive numbers after the decimal point.
@BrianKasenLFP Жыл бұрын
Your links don't work!
@techhelptoday274 Жыл бұрын
Thank you for letting me know. There was a change in the website that mangled some links. All links work now. I appreciate the feedback. - Rich
@sharonannis103 Жыл бұрын
THANK YOU! You saved me so much time just be doing the excel TEXT function!!!!
@ClaudiaAgostinho Жыл бұрын
In Office 365 only works the first option. In older versions I used the DDE and was easier
@shanhussain3202 Жыл бұрын
Thank you very much and appreciated .
@techhelptoday274 Жыл бұрын
You are very welcome!
@IvanIvanov-us7yu Жыл бұрын
Hello! Could you tell, please, how to display common fractions? For example, I have 0.5 in Excel and I need 1/2 in Word. Can't find information anywhere.
@azhjustinkanda7420 Жыл бұрын
Thank youuu this video helped me so muchhh
@techhelptoday274 Жыл бұрын
Glad it helped!
@bilallechvien4558 Жыл бұрын
nice video
@techhelptoday274 Жыл бұрын
Thank you. Glad you liked it.
@gregdubz3522 Жыл бұрын
Thanks. but what if you are filling out a form where you need the comma for a large number but you also do NOT want the comma if the value is 0? Example: 1,000.00 and 0.00 in the same data set.
@techhelptoday274 Жыл бұрын
If you use the code #,##0.00, the comma will only appear if you have four or more digits to the left of the decimal point.
@GLITCH15_17 Жыл бұрын
@@techhelptoday274 Hi there, am trying to use this formula in my Mail Merge Word doc: #,##0.00 however I need as separator not a "'," but a "." and then for decimals I need a "',". So basically instead of having 2,546.37 I need to have 2.546,37. Is this achievable?
@tubeguiller007 Жыл бұрын
Thank you so much for this video...
@techhelptoday274 Жыл бұрын
You are very welcome. Hope you found it useful.
@butterfly06830 Жыл бұрын
This is GREAT ! Thank you for sharing Help Tech... NP
@techhelptoday274 Жыл бұрын
Glad you enjoyed it, Jasper. Thanks for the feedback.
@techhelptoday274 Жыл бұрын
I found another nice trick that ChatGPT can do: I asked it to "summarize the following article" and then pasted in a 2,000-word article from the Wall Street Journal. ChatGPT then quickly gave me a nice 125-word summary. Yes, lots of details were missing, but it did a good job on the main points - and saved me some time! - Rich
@dmsarojani4173 Жыл бұрын
Thnkx its good
@techhelptoday274 Жыл бұрын
You're very welcome!
@mirama765 Жыл бұрын
Good day! {MERGEFIELD TaxItem.TaxRate \# ##%} doesn't print the 0%. We see only the percentage sign, the ZERO desappears completely... 6%, 12% are printing without problem, but not ZERO%. Please help.
@techhelptoday274 Жыл бұрын
Use the code: \# 0% Note that the # symbol will display all numerals except a leading zero. By contrast, the 0 symbol will display all numerals including a leading zero (or a following zero after the decimal point). For example the format code ##.## might display a number as 3.1 while 00.00 will display the same number as 03.10. I hope this helps.