Enter key does not get translated when doing a mail merge into word from excel

5 pts.
Tags:
Excel 2007
Microsoft Excel Mail Merge
Office 2007
Windows 7
We are using Mail merge to automate status report generation for our projects. The data source is excel 2007 spreadsheet.

The merge field in excel has multiple lines concatenated with a enter key coded as Char(13) in excel. In some places this key gets translated as _x000D_ in word. This happens only in a few PC's while other PCS word is able to recognize and translate this from excel. Is there any compatibility issue that we need to lookat. All the PC's are running Office 2007 and a combination of XP/Windows 2007.

All tab entries (char(9) are getting translated correctly in all versions of word). One more observation is that this translation does not happen correctly if this mergefield is placed in a word table  

Any pointers / help in resolving this issue will be appreciated

Thanks

Karthik

 



Software/Hardware used:
Windows / Office 2007

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following