Embedding foreign languages in VBA/VB6 code

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gordon Filby - 09 Aug 2004 14:08 GMT

Hi,

Up to the present I have been addressing scientific researchers to Email
them about papers they have published in scientific journals that I access
via a proprietary database. The Title, Journal etc below are grabbed
programmatically (VB6) from this database and the mail is first saved and
then sent.

The core of the code is:

'Compose e - mail

strmessage = vbCrLf & GlazeText2 & vbCrLf & vbCrLf & Salutation & vbCrLf &
vbCrLf

strmessage = vbCrLf & vbCrLf & vbCrLf & Salutation & vbCrLf & vbCrLf

strmessage = Salutation & vbCrLf & vbCrLf _

& "Scanning a current literature database I came across the abstract to your
paper: " & Title & vbCrLf _

& "in " & Journal & "." & vbCrLf & vbCrLf _

Blahblah .....snipsnip

With objMail

.Recipients.Add EmailAddr

.Subject = "Your recent paper in " & Journal

.Body = strmessage

.Save

End With

Using essentially the same code, I would now like to go a step further and
address authors in their native language. In other words, the text in

Scanning a current literature database I came across the abstract to your
paper: " & Title & vbCrLf _

& "in " & Journal & "." & vbCrLf & vbCrLf _

Blahblah .....snipsnip etc

will then be in Russian, Spanish, French, Portuguese ie all languages which
use different character sets to the one I've been using up to now.

Is this possible and if so, how? Do I need additional add-ins ?

Be grateful for any suggestions.

Regards,

Gordon Filby

Reply to this Message

Cindy M -WordMVP- - 18 Aug 2004 13:10 GMT

Hi Gordon,

I think, to a certain extent, this will depend on the version of Word
involved. If you have Unicode fonts installed that support the full range of
Unicode characters, all the characters for the languages you mention should be
available to use in Word without any additional IME support.

What I'd do, then is set the "static" text up - as full paragraphs - in Word
documents by language (and formatted with the appropriate language),
bookmarked per entry, and have your code pull in the appropriate entry (Insert
File).

The only problem I can imagine might be with passing the data from the
database in Russian. Not sure what will happen to the Cyrillic characters...

> Up to the present I have been addressing scientific researchers to Email
> them about papers they have published in scientific journals that I access
[quoted text clipped - 32 lines]
> End With
>

> Using essentially the same code, I would now like to go a step further and
> address authors in their native language. In other words, the text in
[quoted text clipped - 8 lines]
> will then be in Russian, Spanish, French, Portuguese ie all languages which
> use different character sets to the one I've been using up to now.

> Is this possible and if so, how? Do I need additional add-ins ?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)

Reply to this Message