Hi,
I have a mail merge set up to print address labels and product codes in order to send product samples out to customers.
Unfortunately there is a problem with one field - a field on the excel spreadsheet called SampleCode10 is showing as an 8 character code (our company's product code - usually in the format of 2 letters, 1 number, 1 letter and then 4 numbers) in the excel spreadsheet, but when this is pulling through into the word document it is always showing as 12:00:00AM. All of the other SampleCode fields are showing the correct answer except for this one and I'm completely stumped at how to fix this. I've pressed Alt + F9 but the field doesn't show any special formatting so apart from that don't really know what else to check.
Thanks in advance for any help!
Craig
I have a mail merge set up to print address labels and product codes in order to send product samples out to customers.
Unfortunately there is a problem with one field - a field on the excel spreadsheet called SampleCode10 is showing as an 8 character code (our company's product code - usually in the format of 2 letters, 1 number, 1 letter and then 4 numbers) in the excel spreadsheet, but when this is pulling through into the word document it is always showing as 12:00:00AM. All of the other SampleCode fields are showing the correct answer except for this one and I'm completely stumped at how to fix this. I've pressed Alt + F9 but the field doesn't show any special formatting so apart from that don't really know what else to check.
Thanks in advance for any help!
Craig