MS Word-Date Problem In Mail Merge | Number is appearing instead of the date in mail merge | Hindi

मेईल मर्ज में date डिस्प्ले का प्रॉब्लेम | मेल मर्ज में तारीख की जगह नंबर दिखनेका प्रॉब्लेम कैसे हल करे | मेलिंग टेब | हिंदी ट्यूटोरियल
🔗🔗🔗🔗🔗🔗 Related Video 🔗🔗🔗🔗🔗🔗🔗🔗🔗
MS Word Tutorial Part-048
Mail Merge Using MS Excel | Use an Existing List in Mail Merge | Mailings Tab | Hindi
• MSWORD-048-Mail Merge ...
---------------------------
List of Date formatting with Example
"dd-MM-yy" - 15-08-47
"dd-MM-yyyy" - 15-08-1947
"dd-MMMM-yyyy" - 15-August-1947
"dd-MMM-yyyy" - 15-Aug-1947
Hi,
Welcome to Mr. Coding Channel to learn something new.
In this, we will learn how to solve the Date problems while using mail merge.
Sometimes Number is appearing instead of the date in the mail merge.
So it's quite easy just to go through the video.
-----------
🔵 MS Word Tutorial Playlist
bit.ly/MsWord-Tutorial
-------------
🟢 Tally Tutorial in Gujarati
bit.ly/TallyGujaratiTutorial
-------------
🧒📘 FaceBook
/ mrcoding33
-------------
📷 Instagram
/ mrcoding33
-------------
🔵 Join Our Telegram Channel
t.me/mrCoding33
-------------
🌐 Website
mrcodings.com
#DateInMailMerge, #NumberInsteadOfDate, #MailMergeDateProblem, #MailMergeProblems, #MrCoding, #MrCoding33, #BestTutorial

[@jagdishbhaiparmar1290]

thankyou aapka video mere liye bahut kam aaya iske liye aapka bahut bahut shukriya aapki madad se Mera bahut achcha kam ho gaya thank...JD

[@aniketpatil6286]

Sir Thank you first this problem is solved but std 10th like this ko superscript kaise kare mail maerge file mei

[@GopalJrCollege]

Thabk you

[@LOVELYERA]

Top of the tutorial brother keep it up.....

[@MrCoding]

Thanks ✌️

[@samsonlal9899]

What a explanation 👏👏👏👏👏

[@MrCoding]

Thanks

[@techosity]

Thank you very much done

[@MrCoding]

always welcome

[@ughrowie]

thank you!!

[@MrCoding]

You're welcome!

[@mvhigh11]

Thanks ho gaya

[@MrCoding]

👍👍

[@nitinchouksey2466]

Nicely explain

[@MrCoding]

Thanks and welcome

[@hemanthkumar6663]

Thanku you so much

[@MrCoding]

always welcome. 👍👍

[@user-oo4zf9bv9d]

Thanks sir

[@MrCoding]

always Welcome

[@ravikiran4662]

Problem solved nice video

[@MrCoding]

Thank you very much

[@cricketwithvineet9820]

Very nice sir

[@MrCoding]

Thank you👍

[@pappubora506]

nice my problem solved

[@MrCoding]

Thank you.....

[@kamleshmakwana2925]

solid bro

[@MrCoding]

Thank you

[@chaitanayaA]

thanks a lot brother you saved a lot of time of mine

[@chaitanayaA]

Subscribed

[@MrCoding]

You are welcome

[@MrCoding]

Thank you so much

[@kumarakashchand9433]

Sir alt+f9 click krne pr search button open ho jaa rha h sevices me koi option enable Krna hoga kya sir btaiye

[@MrCoding]

aap jis keyboard se try kar rahe ho us keyboard ka photo hame insta me bhejiye

[@user-ef4dd8kq5c]

SIR AK PROBLEM HO RAHA HAI... INSIRT FIELD MARGE MEI MERA FIRST NAME LAST NAME OR OTHERS K JAGHA MEI F1 F2 KARKE SHOW HO RAHA HAI.. PLEASE REPLY ... THANK YOU

[@MrCoding]

Jo bhi Excel ya CSV file aapne connect ki hogi usaki first row check kare wo shayad blank hogi.
Solution : koi bhi Excel ya CSV me list ho usaki first row me column ke Naam hone chahiye aur koi bhi cell merge nahi hona chahie.
Thank you....

[@unknwn_usr3077]

In excel, I have a cell with NIL as value but after mail merge, it's showing 0 in Ms Word.. What is happening?
Also, some numbers are not fetched correctly, 1 becomes 1.00000000089 and 2 becomes 1.999999099 something like that... Plz help

[@MrCoding]

Thank you for your question please watch below given video link
th-cam.com/video/vrIN80BqnRk/w-d-xo.html

[@nayanmondal5716]

Bhai mera all table par same data araha hain
Iss problem ko kaise solve kare batayee

[@MrCoding]

dusare record se pahele "Next Record" Rule ka use kare, ho jayega. agar "Next Record" Rule ke bareme nahi pata to niche Video link di hai, wo video dekh lijiyega
th-cam.com/video/9j9HlxPoWew/w-d-xo.html
Thank you

[@ajayrane9618]

Why zero comes at the time of Mail Merge-Specifi for text word

[@MrCoding]

unable to understand, please explain in detail.
Thank you

[@Pk.dwivedi]

Showing other data in minus please help

[@MrCoding]

alt+f9 karke sirf date field ke liye formating karna krna hai dusare sabhi field me koi changes nahi karne hai. Thank you

[@sanjaysahare4839]

Sir, ms word me mail merge hai lekin usme doted box aa raha hai usko remove kise kare.

[@MrCoding]

mail merge create karne ke baad cursor ko mail merge ke content pe rakhie, fir Layout tab pe click kare, usame left side Table group me ek option hoga "View Gridlines" wo bandh kar dijiye, ho jayega
Thank you

[@sahid_sk007]

Aj mera v Aisa ho gya , but thik nehi horaha hai sir ,

[@MrCoding]

Please explain in detail

[@nitinchouksey2466]

What to do if in word file after mail merge we have date in 10 to 12 pages and in all pages date format is MM-DD-YYYY then how to change in all pages

[@MrCoding]

abhi jagaha pe changes karne ke liye aap replace ka option use kar sakte ho.
Example: suppose filed kaa naam "Birth_Date" hai.
Alt+F9 key press kare aur {MERGEFIELD Birth_Date} me se sirf "Birth_Date" ko "Birth_Date \@ "MM-dd-YYYY"" se replace kare, ho jayega

[@nitinchouksey2466]

Try Kia but nhi hua

[@MrCoding]

@@nitinchouksey2466 ok to fir manually sab jagah pe change karna padega

[@nitinchouksey2466]

@@MrCoding okk

[@akshayparmar5536]

Alt + F9 se nahi ho Raha hai aur koi tarika hai?

[@MrCoding]

Uninstall MS Office and install 2016 or above version then try, It will work. Thank you

[@jyotisachdeva5181]

mail merge me excel sheet select nahi ho rahi to kya karen

[@MrCoding]

shayad MS Word install karne me problem hoga, ek baar MS Office uninstall kare aur fir se naya setup install kare, ho jayega, Thanks

[@farhanalam8352]

Sir I tried but not working.

[@MrCoding]

Update your MS Office version. Thank you

[@shyamm9940_Dailybites]

I need Indian commas in mail merge sales amount
Example 10,000
1,00,000
1,50,000
11,79,996.00

[@MrCoding]

ye video me bataya hai, pura dekhiye ga
th-cam.com/video/vrIN80BqnRk/w-d-xo.html

[@YASHPALSINGH-cm1iq]

Excel mei date format dd-mm-yyyy hai jabki mail merge mein mm-dd-yyyy ho ja Raha hai , problem kaise solve karein sir

[@MrCoding]

video me dikhai gai same process aapko karni hai
mail merge karne ke baad Alt + F9 key press kare fir jaha pe date ka field hai waha pe aapko {} ke andar aakhir me @\ "dd-MM-yyyy" likhana hai. ho jayega

[@YASHPALSINGH-cm1iq]

@@MrCoding I'll try, sir

[@MrCoding]

@@YASHPALSINGH-cm1iq agar ho sake to Alt + F9 press karke muje insta pe screenshot bhejiye

[@YASHPALSINGH-cm1iq]

@@MrCoding nahi ho raha hai sir, jaise aapne bataya tha vaise hi Kiya lekin fir se MM-ddd-yyyy format mei aa Raha hai jabki excel sheet mein wo dd-mm-yyyy format mei hai.

[@MrCoding]

@@YASHPALSINGH-cm1iq try this. Excel ka format dd-MMM-yy kardo fir try karo