#1
|
|||
|
|||
mail merge treating CITY as DATE
I have an odd one
I'm creating a mail merge to print out envelopes. The document is in Word2010, the database is Excel2010 all the other fields I merge are working fine, but one of my fields comes out in the Word Document as 12:00:00 AM even though the source data is a text field ( the city of the address ) I"ve tried ensuring that the Excel data is formatted text, I"ve tried fiddling with the format of the receiving field ( it is formatted just like the others ) help, Please |
#2
|
||||
|
||||
Hi woody,
Your description suggests the field has mixed data types, not just city names, and Word has interpreted the field as containing dates/times. In such a scenario, text strings evaluate to 0 and may therefore appear as 12:00:00 AM.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Hi Paul - thanks very much for answering and helping, I appreciate it
If I understand what you mean by "field", that would be the column of data in the excel spreadsheet/database that contains all the city names, do I have that right ? What you're suggesting was my first thought as well, however, I've been over the excel data, and it's all text ( and formatted as such ). Also, EVERY city name comes out wrong, not just some of them. Also, that column is formatted the same as the columns before and after it, but they are working fine. any more thoughts ?? thanks a lot woody |
#4
|
||||
|
||||
Hi Woody,
In this case, field = column. Can you attach a workbook with some sample records and a mailmerge main document containing the corresponding mergefields to a post? You can do this via the paperclip symbol on the 'Go Advanced' tab.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
Hi Paul - thanks very much again for your help
I was hesitating before sending you the records and document because it's confidential information. I was going to give you an edited version without the confidential stuff, but realized that I would be changing the situation if I did, so I tried more stuff before doing so. I still don't know why it wasn't working, but now it is - yeah, yeah, I know you hear that all the time, so yes, I realize ( also knew that all the time ) that it was clearly something I had done wrong. I still don't know what I was doing wrong, but here's what I did that fixed it :
thanks again, I really appreciate your willingness to spend time helping me. best regards woody |
#6
|
||||
|
||||
Hi woody,
I'm glad you've got it sorted. FWIW, I don't regard it as wasting my time.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#7
|
|||
|
|||
it's worth a lot , Paul, thanks again
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Issue with date format in mail merge document | walshjod | Mail Merge | 4 | 11-28-2012 04:46 AM |
Date picker mail merge error. | dan1 | Mail Merge | 7 | 06-28-2012 03:00 AM |
Mail merge will not format date field generated by Excel IF statement | borntorun75 | Mail Merge | 3 | 12-16-2011 06:28 AM |
treating text like an image | gib65 | Word | 2 | 08-31-2011 07:20 PM |
Date not transfering to mail merge correctly | tonywatsonmail | Mail Merge | 1 | 07-01-2011 05:30 AM |