Home |
Search |
Today's Posts |
#1
|
|||
|
|||
assistnace with mailmerge dates from excel
I have a main word document merging a record label from an excel
worksheet. The merge is successful for all fields that are text fields but i am having a problems with date fields, they are merging correctly but when the date field is empty the merge field is filled with a default date of today's date. I'm using word 2002 SP3 and the same version of excel. The excel worksheet is being populated by a VB.NET app were all the required printed record labels are selected. The app fills the excel sheet with all the appropriate data fields and retains there format, ie date_to is date format and Name is string ect. When a text field is empty nothing is passed to the main merge document but when a date field is empty a default date is passed. THe date fields have been causing a few problems and any info would be much appreciated. Thanks |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Dates formatting in Word | Mailmerge | |||
Mailmerge calculated dates from Excel | Mailmerge | |||
Mailmerge on word using excel data | Mailmerge | |||
Mailmerge using Excel via DDE | Mailmerge | |||
Mailmerge from EXCEL, custom format problem | Mailmerge |