Mail Merge: Solve Mail Merge Number,Date,Currency,Time Format Problem in MS Word Bangla
Mail Merge: Solve Mail Merge Number,Date,Currency,Time Format Problem in MS Word Bangla
Mail merge is a useful tool to create a set of documents that are essentially the same but where each documents contain unique elements. However, when we merge some mails, we should pay more attention to the format of date, currency and number. This tutorial will show you how to format date, currency and number properly in word during mail merge.
To get the date format you want, you can add a formatting picture switch as follows:
• select the mergefield;
• press Shift-F9 to expose the field coding. It should look something like {MERGEFIELD MyDate} where 'MyDate' is your mergefield's name;
• delete anything appearing after the mergefield's name and add '\@ "dd-MMM-yy"' to the field, as in {MERGEFIELD MyDate \@ "d MMMM yyyy"}. With this switch your date will come out as '2 August 2008'. Other possible date formatting switches include:
. \@ "dddd, d MMMM yyyy";
. \@ "ddd, d MMMM yyyy";
. \@ "d MMM yyyy";
. \@ "dd/MMM/yyyy".
Formatting an Excel Mail Merge Field
To apply number formatting to an Excel mail merge field:
formatting Excel mail merge field in a Word document
Select the field, such as Amount, as shown in this example.
Press [Alt] + F9 to reveal the field coding. Or, right-click on the mail merge field and choose the Toggle Field Code option. You should now see the actual field code for the field which should look something like { MERGEFIELD Amount }.
Edit the field by simply inserting a numeric switch code to the end of the field. For instance, to show a currency format for this example, change the field to show as { MERGEFIELD Amount \# $,0.00 } (see other examples below).
Press [Alt] + F9 again.
Position the cursor anywhere in this field and press the [F9] function key to update it. Or, right-click the field and choose Update Field.
Preview the results to confirm the number displays with the formatting you want to see in the document. For this example, the amount will display as $1,000.00.
Run the mail merge.
I think you have enjoyed this video.
If this tutorial really helps you, please like, comment, subscribe and share with your close friends. This is #ms_excel #bangla #tutorial #mamun_academy
............................................................................
..............Subscribe to Get More Videos...........
https://www.youtube.com/c/MaMuNAcadem...
............................................................................
..................................................................................................
Most Favorite Videos
আমার ভিডিও /টিউটোরিয়াল কোথা থেকে শুরু করবেন ?
• How My Tutorial Arranged_About MamuN Acad...
MS Excel Bangla Tutorial Playlist :
Excel Super Secret Tips & Tricks: https://goo.gl/5qSphJ
Mastery of If Function Bangla: https://goo.gl/jY76m4
MS Excel Essential Course : https://goo.gl/7EX1hk
MS Excel Intermediate Course: https://goo.gl/iatnNz
MS Excel Advanced Course: https://goo.gl/WFrvzU
MS Excel Formulas & Functions: https://goo.gl/7Da7oZ
MS Excel Pivot Table Magic: https://goo.gl/NGp13W
MS Word Essential Course: https://goo.gl/SVXefG
Magic of Conditional Formatting Bangla : https://goo.gl/j4N3sH
Mastery of VLOOKUP Function : https://goo.gl/1YAZ5y
XLOOKUP : A New Awesome Excel Function : http://bit.ly/2rbQSj0
Result Sheet Making Bangla : https://goo.gl/VnuZk6
Salary Sheet Making Hidden Tricks : https://goo.gl/KXsfyh
Master of Pivot Table : https://goo.gl/PaGUzj
MS Word Magic and Tips and Tricks : https://goo.gl/6b25kB
MS PowerPoint 2019 Bangla: https://goo.gl/eoeeMm
MS PowerPoint Tutorial Bangla : Be Pro : http://bit.ly/2PYIcqR
..................................................................................................
.................Social Media.................
Twitter : / cumamun
Google+ : https://plus.google.com/mamunacademy
LinkedIn : / abdulla-al-mamun-172629b4
Instagram: / al-mamun36
..............................................
........................................................
Music Credit goes to: "Royalty Free Music from Bensound" & http://www.bensound.com
Intro/Outro/Banner Creator:
Official™ ► http://bit.ly/OffTMDesigns
Glitchy FREE 2D Intro Template | After Effects Free Intro Template
.........................................................
Stay Tuned with Mamun Academy to get more Videos with Tips and Tricks.