Reply to thread

Message: [QUOTE="Mr. Walsh, post: 7431971, member: 5581"] I have found a solution to this problem. Prior to me figuring out a solution; my Publisher document looked at the first 3 Excel columns that I placed the data in (Student name=A2, Employee ID=B2, certificate expiry date=C2. I used mail merge to import that data into my 3 blank Publisher fields. Sometimes I would get zeros showing up on my certificates (employee ID) even though the cells they were looking at was blank. I was formatting the date field in Publisher document with the mmmm-dd-yyyy format and that is when the dates were showing up in the certificates - even the blank ones that did not have a student name. If I left the date field as the default mm-dd-yy, then the field would be blank if the rest of the data fields were blank, but the date field with student name data in A2 would also have that same format eg 02-20-18 instead of the February-20-2018 that I wanted. In my data sheet (spreadsheet) I created 3 more columns that refer to the original data columns. In the excel data fields that publisher looks at I have a formula in F2 =IF(ISBLANK(A2),"",A2). (A2 is the student name). I also have the date field (H2) looking to see if there is data in the student name cell, if there is a name there, then the expiry date is inserted, otherwise the date field in the Publisher document is blank. =IF(ISBLANK(A2),"",C2). The same formula applies for the employee ID. =IF(ISBLANK(A2),"",B2) Now I can have one student in for a course but still print out a full sheet of certificates with one students name filled in and the rest have the 3 blank data fields (Name, employee ID and expiry date) that can be filled in by hand later on. [/QUOTE]

Verification