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!
Great suggestion, Crede! I should have included that. HansV MVP has a nice solution at answers.microsoft.com/en-us/msoffice/forum/all/formatting-a-percentage-in-a-merge-field/7a62c1e6-250e-4483-991b-3ab40b740443 . And thanks for the kind words.
Thanks for the video. I think it's incredible that we need to deal with such things in 2022. As usual, big thanks go to Microsoft for requiring a time-consuming workaround in each and every feature we touch...
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.
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
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.
Thank you. Question: When we merge into outlook does merge at once all the letters together, or it separates in single letter for each email automatically? does it merge into the outbox and then later we decide to e-mail, or it delivers the email right away after merging. I ask because I am afraid to e-mail wrong letter or to wrong person, who knows, it would be ideal when merging, should go to outbox or to a special box, and to be reviewed and then we email.
You have a valid concern. Always test a Mail Merge email message by sending it to yourself. You can send several copies to yourself simply by repeating your email address in your database file.
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 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?
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!!!!
Hello, I have two different accounts in MS Outlook 365 I want to mail merge from a word file to one of the accounts. However, I made that account a default still sending from the other account which I don’t want. Can someone please help me with this?
If in Word you click "Mailings > Select Recipients > Choose from Outlook contacts", you should be able to choose which Outlook Profile you want, and which Contacts list in the profile you want. If that is not possible, I suggest exporting the contact list to Excel and using that as your data source. Hope that helps.
too long music is not funny. Totally annoying. Regarding information too long of a talk. Please you know too much you are a good expositor but please pretty please make it shorter... it would save everyone a lot of time.... Too much talk man... OMG
@@techhelptoday274 I have to say, I may wish for something shorter, but I always come back to your channel whenever I have a doubt. Sorry for my ways, but thank you very much for your understanding and accepting my rant. You are a splendid teacher.
Well, there is no Excel function that can convert numbers or dates in to words such as one, two, etc. But, you can create your own custom function to do that using VBA. Here is a link from Microsoft that might help you: support.microsoft.com/en-us/office/convert-numbers-into-words-a0d166fb-e1ea-4090-95c8-69442cd55d98
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.
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.
Tried several techniques, but hands down this is the best one which had explained properly and clearly!
Glad it helped! Thanks for letting me know.
This is an excellent tutorial - very thorough and easy to follow
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!
Glad it helped! Thanks for your feedback.
THANK YOU! You saved me so much time just be doing the excel TEXT function!!!!
Yes. Hands down, the best tutorial. Quick fix using picture switch. Thank you for the lesson!!
Thank you, Thank you!!!! You are a very good teacher!
This was the best help I found for currency and date, Thank you!
I just like this old man"Rich" keep it up
Very thorough and helpful - thank you :)
A great presentation, easy to understand, and very helpful. One thing missing which would be more useful for me would be to add percentages.
Great suggestion, Crede! I should have included that. HansV MVP has a nice solution at answers.microsoft.com/en-us/msoffice/forum/all/formatting-a-percentage-in-a-merge-field/7a62c1e6-250e-4483-991b-3ab40b740443 . And thanks for the kind words.
What are the codes for percentages? Thank you for this video!
THANK YOU! I've used the DDE method for years and now it stopped working. Your video was a life saver.
Glad it helped! It's a real shame about DDE.
DDE saved the day! My date format kept showing as the numerical dates ex, 45678. DDE put it in the right format.
very helpful video - solved my issue with mail erge and figures with excesive numbers after the decimal point.
works one day and not the next. Love your instruction style! Thank you!
You're welcome! Good luck with it.
very good and clear explanation.
Glad you think so!
Thankyou very much for the clear explanation..... I have used it into my work ......it is very helpful .....
Hope for your more vedios....Godbless...🙂
You are most welcome. I am glad you found it useful.
Very helpful, well done
Thanks for the video. I think it's incredible that we need to deal with such things in 2022. As usual, big thanks go to Microsoft for requiring a time-consuming workaround in each and every feature we touch...
Great comment. I totally agree!
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
Post Decimal solutions is unique... Thank you so much
Happy to help.
Awesome!! Option no. 3 works for me. Thank you so much 🎉 ..and I subscribed! 😊
Thank you so much. Second option of converting to text functions worked for me.
Thanks for the feedback. The Excel TEXT function is probably the simplest way to handle the problem.
Fantastic sir, it was easily understood and easily done. Thank you so much sir.
You are most welcome. Glad you found it useful.
I have never seen such a nice presentation before! Great!
Thanks for the feedback. I'm glad you liked it!
So helpful! And it works! Thank you.
Great to hear!
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.
Awesome!! Thanks!! My problem solved☺️
Thank you
Thank you so much. Second option of converting to text functions worked But the Unicode language file does not work. Please reply
I'm sorry to hear you are having trouble with a Unicode language file. Could you please give me more details on this problem? - Rich
Unicode language indian marathi font word file does not work. Please reply
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
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.
Thank you so much your video saved my report!
You're so welcome! I'm glad it helped. - Rich
Such a nice presentation. Thankyou
You are most welcome. I hope you found it useful. - Rich
Thanks. This was very helpful.
Glad to hear it!
Thank you. Question: When we merge into outlook does merge at once all the letters together, or it separates in single letter for each email automatically? does it merge into the outbox and then later we decide to e-mail, or it delivers the email right away after merging. I ask because I am afraid to e-mail wrong letter or to wrong person, who knows, it would be ideal when merging, should go to outbox or to a special box, and to be reviewed and then we email.
You have a valid concern. Always test a Mail Merge email message by sending it to yourself. You can send several copies to yourself simply by repeating your email address in your database file.
Thank you very much and appreciated .
You are very welcome!
Hi, I am facing error in word output. My alphanumeric value viz. MTX3852 is displayed as ZERO in word. Please help to get it fixed. Thanks in advance.
Thank you, kindly!
You're very welcome!
Sir, Thank you so much. Superb and Unique Teaching.
You are most welcome.
Thank you very much, Sir.. This is so helpful!
You're very welcome! I'm glad you found it useful.
Thanks. Very useful. Solved my problem
Glad it helped.
Hi how to use ordinals from excel to word pls help
Good question. Use the code: \* Ordinal
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.
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.
@@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?
Thank you!
i loved the content.
Glad you enjoyed it, Hashim!
That was helpful! Thank you.
You're very welcome. I'm glad you found it useful.
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!!!!
Hello,
I have two different accounts in MS Outlook 365 I want to mail merge from a word file to one of the accounts.
However, I made that account a default still sending from the other account which I don’t want. Can someone please help me with this?
If in Word you click "Mailings > Select Recipients > Choose from Outlook contacts", you should be able to choose which Outlook Profile you want, and which Contacts list in the profile you want. If that is not possible, I suggest exporting the contact list to Excel and using that as your data source. Hope that helps.
DDE Worked !!!! Thank you!
Glad it helped. Thanks for letting me know.
Thank you Sir. help a lot
Thanks for your note. I'm glad you found the video useful.
Tnx a lot!
In Office 365 only works the first option. In older versions I used the DDE and was easier
Awesome tip...
Glad you liked it.
Useful information
Binder, glad you think so!
nice video
Thank you. Glad you liked it.
its easier to use codes, i think
Thank you sir! #reallifesuperhero
You are most welcome. Glad you enjoyed it.
None of the methods worked for me.
Sorry to hear that. What version of Word were you using? What kinds of problems were you seeing?
too long music is not funny. Totally annoying. Regarding information too long of a talk. Please you know too much you are a good expositor but please pretty please make it shorter... it would save everyone a lot of time.... Too much talk man... OMG
OK. Thanks for taking the time to respond. All types of feedback are appreciated.
@@techhelptoday274 I have to say, I may wish for something shorter, but I always come back to your channel whenever I have a doubt. Sorry for my ways, but thank you very much for your understanding and accepting my rant. You are a splendid teacher.
how can we convert Date in to Text ? Example. 16/11/2022 Sixteenth November Two Thousand Twenty Two
After Mail Merge Result
Well, there is no Excel function that can convert numbers or dates in to words such as one, two, etc. But, you can create your own custom function to do that using VBA. Here is a link from Microsoft that might help you: support.microsoft.com/en-us/office/convert-numbers-into-words-a0d166fb-e1ea-4090-95c8-69442cd55d98
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.
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.