#1
|
|||
|
|||
Mail merge returning blank field
First let me say I apologize but I am not that tech savvy so if i'm not very clear about my issue please forgive me....
I'm trying to do a mail merge with an excel file and when i use the OLE databse file it works fine (other than the comma formatting not working), but when i try and use the merge via excel DDE way I get a blank line. Can someone tell me what I'm doing wrong? |
#2
|
||||
|
||||
Why are you trying to use DDE? That method was deprecated many years ago.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
As I said I'm not that savy so if there is a different method I'm all ears. I use that method becuase I want to keep the currency fomating (with comma's) when it merges into my word document. Is there a better way to do it?
|
#4
|
||||
|
||||
See Mailmerge Number & Currency Formatting in the Mailmerge Tips and Tricks in the 'Sticky' thread at the top of this forum:
https://www.msofficeforums.com/mail-...ps-tricks.html
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Update & Unlink Specific Merge Field in Word Doc from Mail Merge - Excel VBA | RMerckling | Mail Merge | 16 | 05-17-2018 05:19 PM |
How do I mail merge records into table columns with more than one merge field? | tech123 | Mail Merge | 1 | 04-26-2017 07:13 PM |
Mail merge how to link mail merge field value to a column heading | dsummers | Mail Merge | 1 | 05-08-2014 02:59 PM |
Date field inserting merge date in blank field | Lesley | Mail Merge | 5 | 09-30-2013 01:49 AM |
How to ignore a mail merge field if the field is blank | redzan | Mail Merge | 1 | 05-16-2013 08:34 AM |