Mail Merge

R

R.Walker

We purchased several copies of Office Professional and Basic, when executing a mail merge, the Dollar sign is lost in the Word Document, even though the column in the Excell document is Currency. What's up with that?
 
S

SA

R:

Formatting in Excel is really an overlay in the current document. When
pulling data from an external source, only the value of the field or column
is actually transfered between programs. You can re-add the formatting in
Word by simply appending a $ in front of the merge field in the document.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Paste / Hyperlink multiple Excel Spreadsheets to a Mail Merge Excel Source Document 0
Merging from an Excel file with graphics 1
Start a mail merge upon opening the document 1
Mail Merge skipping records/sending one at a time 0
Merge Excel file into Word Document 3
Mail Merge Directory Conditional Page Break 0
Windows 2016- Unable to do mail merge with my secondary email accounts 1
Help with multi-level list 0

Top