Office 2013 Class #51: Fix Word 2013 Mail Merge Number Format Problem: Excel & Access Data Source

Рет қаралды 85,682

10 жыл бұрын

Download files at: people.highline.edu/mgirvin/A...
This video goes with the Highline Community College Busn 216 Computer Applications Class Access 2013.
Topics Covered In Video Word Mail Merge and Number Format Problem with Mail Merge.
1. What is Mail Merge: Connect Table with Fields to Word document to print or e-mail many letters. (00:45 min)
2. Word Letter Mail Merge w Excel Data (Number Format Problem & Field Code Fix) (02:43 min)
Number Rounded to 2 decimals:
Alt + F9 is toggle to show Field Code in Word
Code to add to end: \# 0.00
{MERGEFIELD Score_1} becomes {MERGEFIELD Score_1 \# 0.00}
Percentage:
Ctrl + F9 inserts MERGEFIELD code
{ MERGEFIELD Grade} becomes {={ MERGEFIELD Grade}*100 \# 0.00%}
3. Word E-mail Mail Merge w Excel Data (Number Format Problem TEXT function Fix) (13:40 min)
TEXT function converts a number to text given a certain Number Format
Number Rounded to 2 decimals use:
=TEXT(CellReference,"0.00")
Percentage:
=TEXT(CellReference,"0.00%")
4. Word E-Mail Mail Merge from Data In an Access Database (fix Number problem with Field code as in example 1 above) (18:26 min)
Word 2013 Mail Merge Number Problem. Fix Word 2013 Mail Merge Number Format Problem: Excel & Access Data Source.

Пікірлер: 40

@excelisfun 10 жыл бұрын

Office 2013 Class #51: Fix Word 2013 Mail Merge Number Format Problem: Excel & Access Data Source

@niikolful 9 жыл бұрын

This is so great. You do not know the frustration that this has caused me with those silly decimal points. Love it. Thanks. :)

@lisajackson9325 9 жыл бұрын

Oh my goodness...this was seriously awesome...I have been doing a revolting (but very important) mail merge and DDE would NOT work so I was a bit upset as to how to fix my formatting.....you have made the day of a new business owner many, many miles away in New Zealand...Thank you :)

@mcgcollege3017 6 жыл бұрын

Thank you for explaining this so well. Spent many hours deleting extra zeros

@BrechPro 5 жыл бұрын

I wish my professor could explain any of this like you. THANK YOU SO MUCH!

@FeliciaMarz954 6 жыл бұрын

Thank you so much!!! i spent forever trying to figure this out!

@MrFriedgreentomatos 8 жыл бұрын

"boom" - keep up the excellent work Dr Girven

@vikramraghuwanshi9455 3 жыл бұрын

Very wel explained by you hats off to you , Excellent way of teaching .

@naribhidden1715 9 жыл бұрын

Excellent tutorial. Complete novice with this stuff. Converting decimal to percentage has been a bear with other instructions because none of them say to highlight the entire field, then hit ctrl F9 to add additional brackets to allow to enter formula. Thanks so much!

@marcerocharodriguez 6 жыл бұрын

that formula is not working on office 365

@CelesteAnleu 10 жыл бұрын

You are one of a kind, thanks a mil!

@HappyheartbyNida 6 жыл бұрын

Thanks a lot. your video solved my 3 problems regarding mail merge fields.

@erikavb9148 9 жыл бұрын

Brilliant!!! Thank youuuu!! I managed to do it thanks to you!!!!!!!!!!!!! x

@friendscorner9622 5 жыл бұрын

Very much helpful for me. Well defined. Thanks alot

@mukeshkadkol4759 4 жыл бұрын

Hi Mike, thanks for the video . I have a question; What if I want to broadcast customers with multiple lines? Will they have multiple emails?

@steve6631 3 жыл бұрын

Thank you for posting

@180692Nick 3 жыл бұрын

I do exactly as you said but the numbers format doesn't work. Date format is ok but number keep being like "26,39999999". My office ver is Pro plus 2013.

@friendscorner9622 5 жыл бұрын

I am having another numeric problem in mail merge that is decimal places (e.g 25,625.00) how can it be done in MS Word

@girisharohra8488 3 жыл бұрын

unable to use ctr +f9 in word 2016. when pressed that windows home page opens

@syedkashifnaqvi1268 3 жыл бұрын

But my in my case show me under insert merge field f1 ,f2 ,f2 etc but not the actual name of column?

@mbulelok6741 7 жыл бұрын

The numbers I am using is a million( e.g 1748391.19) and use the text method, I get 1748391.19. I need to separate millions to thousand and hundreds (1 748 391.19). How do I do that?

@creative_gujarati 3 жыл бұрын

You made my day, thnx

@iqbalazeem8636 4 жыл бұрын

Can you please guide me regarding mail merge of bar chart for the students. I want to print the certificate of 240 students with their bar chart of Marks.

@juliangray3968 9 жыл бұрын

We have to send over 700 letters out of access database. Some are sent to individuals some are sent to couples. When letters are sent to couples there is an "and" in between first names. Unfortunately the "and" is also present when the letter is sent to an individual. The only way I know is to individually delete each "and" which is very tedious. How should I fix this problem.

@mbulelok6741 7 жыл бұрын

The numbers I am using is a million( e.g 1748391.19) and use theF9 Trick but I get 1748391.19. I need to separate millions to thousand and hundreds (1 748 391.19). How do I do that? I am on word 2016

@Find_Your_Fit 10 жыл бұрын

This was very helpful for the concepts. Thank you. I have a very large database, so creating a second table with the cells formatted as text won't really work. But what I'm having a problem with is the currency format. What is the format for the switch for this? I have been searching but can't find it. Thanks

@simoiyahector-morales9521 6 жыл бұрын

Hi this is the format for currency \# $, .00

@HBStep 6 жыл бұрын

Thank you for always explaining things so perfectly. I'm late to the party, upgraded office computers from 2010 to 2016 this week. I didn't need to do any of this with 2010, all my merge stuff worked perfect, percents, numbers and dates. So frustrated. Anyway, worked on one document doing the above and worked great, but on the next when I do the percentage tweak, say it's 5.00%, after I finish the above and hit Alt F9, instead of seeing the regular insert merge field I see 0.05. All the other fileds (dates numbers etc) revert back to showing the merge field but not this percent one. What can be going on? I deleted it and re-inserted the merge field several times. The field is called int_1. I expect to see { MERGEFIELD int_1 } but i see .05 while everything else is showing the MERGEFIELD format. Any ideas?

@marcerocharodriguez 6 жыл бұрын

same happening here, did you solve it?

@MegaUmesha 5 жыл бұрын

Thanks Dear

@krn14242 10 жыл бұрын

Thanks Mike. I have used Mail Merge from Excel and it works great.. never knew the Ctrl F9 trick... Thanks. In the past I convert the data before it comes over to Word. I always seem to have an issue with email addresses. Could not get the format correct on the Word Doc side. I was getting the email address twice. Do you have any advice on the correct MM Word format to display email addresses? Merry Christmas to you and your family. ps. Got a reply from Isaac about his GoGos... :) lol.

@excelisfun 10 жыл бұрын

I have never had an issue with e-mail addresses. Is it just the first one? When I Google "mail merge e-mail shows up twice", I get this help from Microsoft: support.microsoft.com/kb/286847

@tonyawilfong1760 6 жыл бұрын

I tried this and it worked for the most part, but my percentages have more then 2 numbers at the end (83.2551%) and only 83.25% shows up, does anyone know how to fix this?

@marcerocharodriguez 6 жыл бұрын

just add \# ##,0000%

@VedangKevlani 4 жыл бұрын

Sir, it doesn't work for me!

@MOSTOFASOHEL 10 жыл бұрын

Mr. Mike hope u r fine this is sohel fm Bangladesh, I always keep look on ur youtube channel for new things. very recently i tried to make pay slip for company staff & worker using word mail merge. the salary sheet is prepared with excel 2010. i able to preper one payslip in one page is there any way that i can make it 6 person payslip in one page, i have tried with label option but that time i miss excel field label. i mean label only show employee name but i want before his name it will show Say category Name, before age it will show Age, Before ID no. It will show ID no. I will be very helpful if u upload solving that prob video

@gooksaad 7 жыл бұрын

🙂🙂🙂

@sandeepsarkar2919 6 жыл бұрын

Mr. Mike... pls advice how to give coma separator in mail merge (in Indian currency format). Like : 12,34,000.00 and 3,65,125.00 and 14,500.00 and 4,500.00 ... Thank you.