Unicode characters problem in MailMerge using Excel
On Mar 16, 12:42 pm, "Peter Jamieson"
wrote:
Which version of Word/Excel, and can you show the code for your
OpenDataSource please?
Peter wrote in message
oups.com...
Hey...
I'm having problem displaying double-byte characters using mail merge
functionality. In my application, we're using Excel sheet as a
datasource for a word template document. We open a datasource using
OpenDatasource method. But when spreadsheet column has a double-byte
characters in its data, in Word document, when we merge the field, it
displays lots of "?" instead.
Data is being displayed fine in spreadsheet.
Also, when I manually open a datasource from a word for the same
spreadsheet and then merge fields, data is perfect. It doesn't display
garbages....
Any ideas/suggestions is appreciated.
Thanks,
- Dhwanit- Hide quoted text -
- Show quoted text -
Hey....We're using office 2003 SP2 for word and excel both...as far
as code goes, call is right here...
ODBC:
m_doc.MailMerge.OpenDataSource(Name:="", _
Connection:="DSN=Excel Files;DBQ=" &
m_strDsName & ";", _
SQLStatement:="SELECT * FROM `Sheet1$`", _
SubType:=WdMergeSubType.wdMergeSubTypeWord2000)
DDE:
m_doc.MailMerge.OpenDataSource( _
Name:=m_strDsName, _
Connection:="Entire Spreadsheet", _
SubType:=WdMergeSubType.wdMergeSubTypeWord2000)
Thanks....
Dhwanit
|