How to fix Excel formatting issues within a Word Mail Merge

Рет қаралды 21,267

2 жыл бұрын

During a Word mail merge from a Microsoft Excel list, some Excel field types do not retain their formatting during the merge. Currency formats are one of those issues.
This video teaches you how to use switches in word to format the incoming currency field day to retain the formatting during the merge.
Let me know what you think.
~ Donna

Пікірлер: 38

@jimwalton9879 Күн бұрын

very good, simple demonstration.

@alcanata6642 Жыл бұрын

This was soo helpful! Years of frustration with DDE and this simple fix made life so much easier for me.

@rochelkreiman5284 Жыл бұрын

I'm having a problem with fraction being inserted into my letter. Looks fine on database, but does not convert onto my letter.

@elaineterry44 Жыл бұрын

THANK YOU!! so helpful and clear very much appreciated :)

@kylewolf1052

Exactly what I needed, thank you Donna!

@DeniseBartle

Extremely helpful!

@sharonhowell3388

Fabulous, that has really helped, thank you!

@reginamontgomery8259 2 жыл бұрын

Thank you! Very helpful!

@DoraniLacey Жыл бұрын

You're my hero - thank you!!!

@cindywright1564 Жыл бұрын

Thank you! You've save me today:)

@kinnaturale3040

Thanks!! This is perfect. What is the switch code for dates I want the dates in text May 11, 2018.

@albertoalarcon3794 2 жыл бұрын

Thank you very much!!

@LindaMachado Жыл бұрын

Helpful! Thanks

@lusiaodos3050 Жыл бұрын

It was really helpful

@rapiiahmad Жыл бұрын

Thank you. I'm having trouble with the subscript format. Can you help me.

@ughrowie

i'm having a problem with mine. in my workbook, it's a date (01-Jan-2023) but when it translates into my word doc, it's a series of numbers (not 20230101, but 4xxxxx numbers). does anyone know how to troubleshoot?

@naybrobk 2 жыл бұрын

Hi Donna, I need to pick your brain. I have an excel worksheet and I’m trying to use it with word as a mail merge. I’m training to make display cards for a quilt show. When I merge the cells are correct however, it seems to only copy part of a cell. I have a cell when the person entering the quilt in the show has to describe or tell a story about that quilt. If someone only types a sentence or 2 it works great. There are a few who have typed a who paragraph. When I merge a few sentences will merge but not all the sentences. I have no clue what I am doing wrong, can you please help me?