Mail Merge - Polish text in mail body

[neveu]

hello,

i'm using the mail merge VBA to generate email that would contain a template and the dinamic information to be pulled out from an excel file.

the problem is that the message of the text has to be in polish and there are specific characters that are not reqcognized in the VBA.

I've set the template message in VBA and the specific characters from Polish are seen as question marks (?).

I've found the ASCII codes from the characters but it don't manage to make them work in the VBA code of the message body.


any ideas hoe should I proceed? or any other way to solve this?

here is the link with the polish characters:
http://webdesign.about.com/od/localization/l/blhtmlcodes-pl.htm

 .HTMLBody = "Szanowni Pa?stwo, Informujemy, ?e na Pa?stwa  koncie znajduj? si? faktury, których ter"  & "<br><br>" & _

 

[John_w]

I don't really follow your explanation, but you could specify the numerical code shown in the table of Polish characters to insert that character where it is required in the HTML body text:

.HTMLBody = "First 4 Polish characters: #260; #261; #280; #281;"

Note - there should be an ampersand (&) before each '#' in the above code. I've had to omit the ampersands because otherwise the forum software translates the numerical code to the display character, like this:

.HTMLBody = "First 4 Polish characters: Ą ą Ę ę"

 

[neveu]

thank you very much for your help... it works great.

i was trying to use a function chr to convert the ascii code into letter.
but it was that simple.

thanks a million