Problem seeing some characters when sending email to Outlook client
fniles
I am having a problem when sending some characters (like a bullet
point that looks like an arrow) thru email that's received in
Outlook.
The weird thing is some Outlook client can see the arrow fine, some
can not.
My Outlook 2003 used to be able to see the arrow ok, but now it
doesn't.
Some Outlook 2007 can see it ok, some can't.
I can see the arrow fine in Gmail.
This is the character that we are having a problem with:
►
That arrow character becomes this in some of the Outlook client:
–
Thank you for your help.
This is my code:
Set poSendMail = New clsSendMail
poSendMail.SMTPHost = "a.com"
poSendMail.UserName = "a...@a.com"
poSendMail.Password = "mypwd"
poSendMail.UseAuthentication = True
poSendMail.delimiter = ";"
poSendMail.AsHTML = True
poSendMail.From = "mye...@mycom.com"
poSendMail.FromDisplayName = "a"
poSendMail.RecipientDisplayName = "fiefie"
poSendMail.Recipient = "m...@mycom.com;mye...@gmail.com"
poSendMail.Subject = "test"
poSendMail.Message = sEmail -> this contains HTML code below
poSendMail.Send
Set poSendMail = Nothing
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:v =
"urn:schemas-microsoft-com:vml" xmlns:o =
"urn:schemas-microsoft-com:office:office" xmlns:w =
"urn:schemas-microsoft-com:office:word" xmlns:ns0 =
"http://www.w3.org/1999/XSL/Format"><HEAD>
<META content="text/html; charset=utf-8" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18928"><!--[if !mso]>
<STYLE>v\:* {
BEHAVIOR: url(#default#VML)
}
o\:* {
BEHAVIOR: url(#default#VML)
}
w\:* {
BEHAVIOR: url(#default#VML)
}
.shape {
BEHAVIOR: url(#default#VML)
}
</STYLE>
<![endif]-->
<STYLE>@font-face {
font-family: Trebuchet MS;
}
@font-face {
font-family: Arial Rounded MT Bold;
}
@page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.25in 1.0in
1.25in; }
P.MsoNormal {
MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; FONT-SIZE: 12pt
}
LI.MsoNormal {
MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; FONT-SIZE: 12pt
}
DIV.MsoNormal {
MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; FONT-SIZE: 12pt
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: blue; TEXT-DECORATION: underline
}
P {
FONT-FAMILY: "Times New Roman"; MARGIN-LEFT: 0in; FONT-SIZE: 12pt;
MARGIN-RIGHT: 0in; mso-margin-top-alt: auto; mso-margin-bottom-alt:
auto
}
SPAN.EmailStyle20 {
FONT-FAMILY: Arial; COLOR: navy; mso-style-type: personal-reply
}
DIV.Section1 {
page: Section1
}
</STYLE>
</HEAD>
<BODY lang=EN-US link=blue vLink=blue>
<DIV dir=ltr align=left><FONT size=2 face=Arial></FONT> </DIV>
<DIV class=Section1>
<TABLE style="WIDTH: 100%; BORDER-COLLAPSE: collapse"
class=MsoNormalTable
border=0 cellSpacing=0 cellPadding=0 width="100%">
<TBODY>
<TR>
<TD
style="PADDING-BOTTOM: 0in; PADDING-LEFT: 0in; PADDING-RIGHT: 0in;
PADDING-TOP: 0in"
colSpan=3>
<TABLE style="WIDTH: 100%; BORDER-COLLAPSE: collapse"
class=MsoNormalTable
border=0 cellSpacing=0 cellPadding=0 width="100%">
<TBODY>
<TR>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; WIDTH:
80%; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt"
width="80%" colSpan=2>
<TABLE
style="BORDER-BOTTOM: medium none; BORDER-LEFT: medium
none; WIDTH: 19%; BORDER-COLLAPSE: collapse; BACKGROUND: red; BORDER-
TOP: medium none; BORDER-RIGHT: medium none"
class=MsoNormalTable border=1 cellSpacing=0 cellPadding=0
width="19%" bgColor=red>
<TBODY>
<TR>
<TD
style="BORDER-BOTTOM: #111111 1pt inset; BORDER-LEFT:
#111111 1pt inset; PADDING-BOTTOM: 0in; PADDING-LEFT: 0in; WIDTH:
100%; PADDING-RIGHT: 0in; BORDER-TOP: #111111 1pt inset; BORDER-RIGHT:
#111111 1pt inset; PADDING-TOP: 0in"
width="100%">
<P class=MsoNormal><A name=top></A><EM><B><I><FONT
color=white
size=2 face=Arial><SPAN
style="FONT-FAMILY: Arial; COLOR: white; FONT-SIZE:
10pt; FONT-WEIGHT: bold">Not
to be outside
a</SPAN></FONT></I></B></EM><o:p></o:p></P></TD></
TR></TBODY></TABLE>
<P style="MARGIN-BOTTOM: 12pt" class=MsoNormal><FONT
size=3
face="Times New Roman"><SPAN
style="FONT-SIZE: 12pt"><BR><BR></SPAN></FONT><B><FONT
face="Trebuchet MS"><SPAN
style="FONT-FAMILY: 'Trebuchet MS'; FONT-WEIGHT:
bold"><o:p></o:p></SPAN></FONT></B></P>
<P style="TEXT-ALIGN: center" class=MsoNormal
align=center><B><FONT
size=5 face="Trebuchet MS"><SPAN
style="FONT-FAMILY: 'Trebuchet MS'; FONT-SIZE: 18pt; FONT-
WEIGHT: bold">a
Solutions: October 14,
2010</SPAN></FONT></B><B><FONT face="Trebuchet MS"><SPAN
style="FONT-FAMILY: 'Trebuchet MS'; FONT-WEIGHT: bold">
<o:p></o:p></SPAN></FONT></B></P></TD>
<TD
style="BORDER-BOTTOM: medium none; BORDER-LEFT: medium none;
PADDING-BOTTOM: 0in; PADDING-LEFT: 0in; PADDING-RIGHT: 0in; BORDER-
TOP: medium none; BORDER-RIGHT: medium none; PADDING-TOP: 0in"
width=21>
<P class=MsoNormal> </P></TD></TR>
<TR>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; WIDTH:
80%; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt"
width="80%">
<P style="TEXT-ALIGN: center" align=center><A
name=thetop><FONT
size=3 face="Arial Rounded MT Bold"><SPAN
style="FONT-FAMILY: 'Arial Rounded MT Bold'; FONT-SIZE:
12pt"><BR></SPAN></FONT></A><IMG
border=0 hspace=0 alt=""
src=cid:alogo.JPG><o:p></o:p></P></TD>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; WIDTH:
20%; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt"
width="20%">
<P style="TEXT-ALIGN: right" align=right><FONT size=2
face=Arial><SPAN style="FONT-FAMILY: Arial; FONT-SIZE:
10pt"><A
href="a.htm">Archive</A>
<BR><A
href="mailto:a...@a.com?subject=Feedback%20about%20a%20Solar
%20Solutions%20a%20Up">Feedback
</A><BR><A
href="mailto:a...@a.com?subject=a%20Solar%20Solutions%20a%20Up
%20Subscription%20Request">Subscribe
</A><BR><A
href="mailto:a...@a.com?subject=Unsubscribe%20from%20a%20Solar
%20Solutions%20a%20Up">Unsubscribe
</A><BR><A
href="a.htm">a
Search</A> </SPAN></FONT><o:p></o:p></P></TD>
<TD
style="BORDER-BOTTOM: medium none; BORDER-LEFT: medium none;
PADDING-BOTTOM: 0in; PADDING-LEFT: 0in; PADDING-RIGHT: 0in; BORDER-
TOP: medium none; BORDER-RIGHT: medium none; PADDING-TOP: 0in"
width=21>
<P class=MsoNormal> </P></TD></TR>
<TR>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; WIDTH:
200%; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt"
width="200%" colSpan=2>
<TABLE style="WIDTH: 100%; BORDER-COLLAPSE: collapse"
class=MsoNormalTable border=0 cellSpacing=0 cellPadding=0
width="100%">
<TBODY>
<TR>
<TD
style="PADDING-BOTTOM: 0in; PADDING-LEFT: 0in; WIDTH:
50%; PADDING-RIGHT: 0in; PADDING-TOP: 0in"
vAlign=top width="50%">
<P class=MsoNormal><B><FONT color=#ffa620 size=3
face="Trebuchet MS"><SPAN
style="FONT-FAMILY: 'Trebuchet MS'; COLOR: #ffa620;
FONT-SIZE: 12pt; FONT-WEIGHT: bold">a
Information</SPAN></FONT></B>
<o:p></o:p></P>
<TABLE class=MsoNormalTable border=0 cellPadding=0>
<TBODY>
<TR>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT:
0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt"
vAlign=top>
<P class=MsoNormal><FONT color=blue size=2
face=Arial><SPAN
style="FONT-FAMILY: Arial; COLOR: blue; FONT-
SIZE: 10pt">► <o:p></o:p></SPAN></FONT></P></TD>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT:
0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt"
vAlign=top>
<P class=MsoNormal><FONT color=blue size=2
face=Arial><SPAN
style="FONT-FAMILY: Arial; COLOR: blue; FONT-
SIZE: 10pt"><A
href="#347114442_Customers">1. Best Rank
Teams Up
With ASES To Enlighten The Solar Energy
Industry</A><o:p></o:p></SPAN></FONT></P></
TD></TR></BODY></HTML>
Jeff Johnson
news:cee40611-db83-48c0...@a36g2000yqc.googlegroups.com...
> Using VB6, I am sending an HTML email using SMTP.
> I am having a problem when sending some characters (like a bullet
> point that looks like an arrow) thru email that's received in
> Outlook.
It's all about the fonts. If the user's font has a glyph for that code
point, then he'll see the character. If not, he won't*. It's not something
you have control over. Your best bet is to use an image for things like
this.
*Or, to put it a different way, "Welcome to the Internet."
fniles
>If the user's font has a glyph for that code point, then he'll see the character
What did you mean by glyph ?
How can I check if the user's font has a glyph for that code point or
not ?
On Oct 15, 12:48 pm, "Jeff Johnson" <i....@enough.spam> wrote:
> "fniles" <fiefie.ni...@gmail.com> wrote in message
Tony Toews
<fiefie...@gmail.com> wrote:
>Thank you for your reply.
>
>>If the user's font has a glyph for that code point, then he'll see the character
>What did you mean by glyph ?
>How can I check if the user's font has a glyph for that code point or
>not ?
It's not the user sending the email who is having the problem. It's
the user receiving the email who might not have the font installed as
chosen by the sender.
Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Jeff Johnson
>>If the user's font has a glyph for that code point, then he'll
>> see the character
>What did you mean by glyph ?
"Glyph" is the technical word for a "visual representation of a character."
The differences in the glyphs are generally what make fonts look different
from each other. For example, a capital A in Times New Roman looks different
from a capital A in Arial and a capital A in Courier New. They're all the
same character and they're at the same code point (U+0041), but each font
file defines different glyphs. Not all font files contain glyphs for every
defined code point (defined by the Unicode standard, that is). When a font
file doesn't contain a particular glyph, the text APIs of a given operating
system will usually draw a "missing character" glyph, which is most often an
unfilled box on Windows and a black diamond with a white question mark on
the Mac (and *nix boxes, I think).
You're most likely to run into unsupported glyphs when you go far afield of
"standard characters." Most fonts include basic Latin characters and often
include other similar characters like Cyrillic and Greek, and maybe even
Hebrew and Arabic. The triangular bullet you have posted is in the "General
Punctuation" subrange at code point U+2023 (which, oddly, is 8227 in
decimal, not 8211 as your post shows; 8211, aka U+2013, is an en-dash).
Basic Windows fonts like Arial, Times New Roman, and Verdana do not have
this glyph, but Arial Unicode MS does. Interestingly, I have OE set to
display in Verdana, but I still see the triangle. Perhaps the text renderer
is smart enough to switch to a font where the glyph is supported, if one
exists on the system.
>How can I check if the user's font has a glyph for that code point or
> not ?
You can't. You have no idea what fonts the recipient will have on his
machine. Web designers learned a long time ago that if you want to do
something fancy, you better make an image, because relying on text is
extremely brittle.
Mayayana
How can I check if the user's font has a glyph for that code point or
not ?
>
In addition to what Jeff said, You really shouldn't
allow MS Office to write your HTML unless you know
that everyone you send to has MS Office. In addition to
being incredibly bloated, MS-generated HTML may use
non-standard code that doesn't show correctly in
Thunderbird, etc.
It's best to write the HTML/CSS yourself. Make sure
it's compatible. And avoid non-common fonts. (I don't
have Trebuchet on XP. I'm guessing that's an MS
Office-specific font. I have OO installed but not
MS Office.)
One option if you don't want to use images might be
•. That's a round bullet in Verdana. In most
fonts it will be a bullet, but of varying size. Virtually
all Windows PCs should have Verdana. If you need
to deal with Macs you should check their fonts. Maybe
Helvetica would work OK.
<STYLE>
.Bullet {font-family: verdana, helvetica; font-size: 24px; color: #CC0033;}
</STYLE>
<SPAN CLASS="Bullet"> • </SPAN>
fniles
This is for intra company usage, so everybody has Outlook and Office.
Say my VB program sends the email to 2 different email addresses say
a...@mycom.com and b...@mycom.com.
a...@mycom.com can see the arrow in his Outlook, but b...@mycom.com can't
see the arrow as arrow in his Outlook.
But, if a...@mycom.com forward the email he got from my program to
b...@mycom.com, then b...@mycom.com can see the arrow in his Outlook.
So, if b...@mycom.com doesn't have the glyph for that code point, how
come he can see the arrow when a...@mycom.com forward the email to him ?
fniles
looks like by the time the email reach them, the ► was converted to
–.
But the weird thing is if through my VB program I send the email to a
client that can see the arrow fine like ► (either an Outlook client or
gmail), then I forward that email to that other client that can't read
the ► in the email sent from the program, now that client can read the
► fine.
So, if that client doesn't have the glyph or font, how could he see
the ► fine when the email is forwarded from another client that can
see it ?
Thank you
On Oct 15, 5:22 pm, "Mayayana" <mayay...@invalid.nospam> wrote:
fniles
The emails were written by some other people in the company, not by
me, so I have no control of what they use (image or font), all my VB
program does it forward their email to another users.
From this code below, do I understand it correctly that the ► is part
of Arial font ?
<P class=MsoNormal><FONT color=blue size=2 face=Arial><SPAN
style="FONT-FAMILY: Arial; COLOR: blue; FONT-SIZE: 10pt">► <o:p></
o:p></SPAN></FONT></P>
Since all the email recipients are in our company, I will be able to
check what font they have, etc.
Where can I check that ?
Thank you again.
On Oct 15, 5:22 pm, "Mayayana" <mayay...@invalid.nospam> wrote:
Nobody
> Those clients in my company that can't read ? in their Outlook, it
> looks like by the time the email reach them, the ? was converted to
> –.
You can't just put any character in HTML source. Some characters are unsafe,
and you need to encode them. If the user was using a decent HTML editor, it
will take care of the encoding, but some users edit the HTML source directly
and are unaware that there are some characters that they cannot use, or use
a bad HTML editor, so you need to make sure that these characters are
encoded.
If you start with a Text only source, not HTML, then this function would
translate unsafe characters so you can embed them in HTML source:
HTMLEncode:
http://www.devx.com/vb2themax/Tip/19162
If someone edited an HTML source, and added unsafe characters, then you need
to do more work. Here is an HTML reference that you could use:
These links come from the above:
HTML 4 Reference:
http://www.htmlhelp.com/reference/html40/
Special Characters:
http://www.htmlhelp.com/reference/html40/structure.html#characters
Nobody
emails, but you didn't say what the overall result that you are looking for,
in case there is an existing solution for what you need.
fniles
My VB6 program reads emails in a POP 3 server, and the emails are base
64.
I can't control what characters can or can not be in the emails.
I use the "DecodeBase64String" function in the POP3 class that comes
with POP3 Sample codes.
After I decode the emails, it is in HTML format.
After that my program sends that emails using SMTP to people within
the company, some are using Outlook 2003, some Outlook 2007.
The email contains arrow like this ►.
When my program sends the email out, some people can view that arrow
in the email, some can not (in their case the ► becomes – or
something else).
The weird thing is if the people that can view the ► forward that the
email to the people that can't view it (if they view the email from my
program), then this people can view the ►. If the problem is their
font, then why would they be able to view the ► when it is forwarded
from the other people ?
The overall result that I am looking for is for everybody in the
company (they are all using Outlook) to be able to view the ► in the
email when the email is sent from my program.
Thank you.
Nobody
versions of IE are more forgiving of HTML errors than others. Also, fonts in
different operating systems may implement more or less characters, even
though the font name is the same. Add to that if the HTML source didn't
include a font name(unlikely), then a default font is used.
Finally, I think you misunderstood my question about the overall problem
that you are trying to solve. What I meant is why did you need to write this
program in the first place? Why does your company want to download and
forward emails? What re they trying to accomplish?
"fniles" <fiefie...@gmail.com> wrote in message
news:2b28d76b-2334-410a...@k22g2000yqh.googlegroups.com...
Thank you for your reply.
My VB6 program reads emails in a POP 3 server, and the emails are base
64.
I can't control what characters can or can not be in the emails.
I use the "DecodeBase64String" function in the POP3 class that comes
with POP3 Sample codes.
After I decode the emails, it is in HTML format.
After that my program sends that emails using SMTP to people within
the company, some are using Outlook 2003, some Outlook 2007.
The email contains arrow like this ?.
When my program sends the email out, some people can view that arrow
in the email, some can not (in their case the ? becomes – or
something else).
The weird thing is if the people that can view the ? forward that the
email to the people that can't view it (if they view the email from my
program), then this people can view the ?. If the problem is their
font, then why would they be able to view the ? when it is forwarded
from the other people ?
The overall result that I am looking for is for everybody in the
company (they are all using Outlook) to be able to view the ? in the
fniles
told to do that.
In the VB6 program, before I send the email, I write it to a TXT file
to see what's in the email, and this is what it says: (it is using
Arial as its font):
<P class=MsoNormal><FONT color=blue size=2 face=Arial><SPAN
style="FONT-FAMILY: Arial; COLOR: blue; FONT-SIZE:
10pt">► <o:p></
o:p></SPAN></FONT></P>
I understand that everybody is saying that it has something to do with
the fact that the font doesn't exist for ► in the client's machine.
But, what is the answer to this question ?
On my machine (uses Outlook 2003) I can't see the ► in my Outlook if
the email is sent from my program (which is also on my machine), but
when I go to IE on my machine and view the TXT file from the email
that I sent from my program (before I send the email I write it to TXT
file), I can see the ►.
Also, I sent the email from my program to another machine that can
view the ► in their Outlook.
Then, I forward that email from that machine to my machine, and now I
can see the ► in my Outlook.
If the problem is my font, then why would I be able to view the ► when
it is forwarded from the other person Outlook ?
Thank you for your help.
On Oct 16, 10:47 pm, "Nobody" <nob...@nobody.com> wrote:
> Outlook uses IE to display emails, and MS Word to compose emails. Some
> versions of IE are more forgiving of HTML errors than others. Also, fonts in
> different operating systems may implement more or less characters, even
> though the font name is the same. Add to that if the HTML source didn't
> include a font name(unlikely), then a default font is used.
>
> Finally, I think you misunderstood my question about the overall problem
> that you are trying to solve. What I meant is why did you need to write this
> program in the first place? Why does your company want to download and
> forward emails? What re they trying to accomplish?
>
> "fniles" <fiefie.ni...@gmail.com> wrote in message
> > in case there is an existing solution for what you need.- Hide quoted text -
>
> - Show quoted text -
Nobody
> Unfortunately I do not know why they want to forward the emails, I was
> told to do that.
You need to ask them. There are ready solutions without having to reinvent
the wheel. See here for example:
http://en.wikipedia.org/wiki/Email_forwarding
You can use Outlook's Rule Wizard to auto forward to multiple emails
addresses at once(I just tested in Outlook 2002), so there is no need to
write software for this.
Also, I have a shared web host account that I am paying less than $20/Month
for, and in the control panel, I can set auto forwarding to multiple email
addresses, so there could be something similar that your company already
has.
> In the VB6 program, before I send the email, I write it to a TXT file
> to see what's in the email, and this is what it says: (it is using
> Arial as its font):
> <P class=MsoNormal><FONT color=blue size=2 face=Arial><SPAN
> style="FONT-FAMILY: Arial; COLOR: blue; FONT-SIZE:
> 10pt">? <o:p></
> o:p></SPAN></FONT></P>
>
>
> I understand that everybody is saying that it has something to do with
> the fact that the font doesn't exist for ? in the client's machine.
HTML files can be Unicode files, so it's possible that you are converting
them back to ANSI. However, they usually start with byte sequence &HFF,
followed by &HFE to indicate that the file format is Unicode. Try using a
Hex editor to see what the character code looks like. Here is a free Hex
editor:
http://www.chmaas.handshake.de/delphi/freeware/xvi32/xvi32.htm
Also, I just checked your first post and noticed this line:
<META content="text/html; charset=utf-8" http-equiv=Content-Type>
"charset" is UTF-8, so that character is encoded, possibly in a sequence of
3 bytes. Some links(Search for FEFF in the first link):
http://en.wikipedia.org/wiki/Unicode_and_HTML
http://en.wikipedia.org/wiki/UTF-8
fniles
I will bring up the idea of Outlook Rule Wizard to them.
>HTML files can be Unicode files, so it's possible that you are converting them back to ANSI.
Did you mean I am converting the ► before I send the email ?
If I do that, why some clients can read it correctly ?
When I read ► in the hex editor, it shows 6 characters
EF
BB
BF
E2
96
BA
>"charset" is UTF-8, so that character is encoded, possibly in a sequence of 3 bytes.
If ► is encoded, what does it mean in terms of what I need to do
before I send the email ?
Thank you
On Oct 17, 12:10 pm, "Nobody" <nob...@nobody.com> wrote:
> "fniles" <fiefie.ni...@gmail.com> wrote in message
DAS
assume the recipient sees what the sender sends in e-mail.
Thus:
1. Keep signs and symbols simple, best in plain text, however boring it
looks.
2. Send pdf to ensure the recipient sees what the sender designs. Even if
sending a document in a 'standard' format such as .doc or .xls. you never
know which version is available at the other end (unless you've checked...).
In this particular case the OP says everyone in the company has the same
software (and same edition), so problems should not often arise.
DAS
--
To reply directly replace 'nospam' with 'schmetterling'
--
"Jeff Johnson" <i....@enough.spam> wrote in message
news:i9afet$uo2$1...@news.eternal-september.org...
Jeff Johnson
news:i9drlu$84e$1...@speranza.aioe.org...
> Outlook uses IE to display emails, and MS Word to compose emails.
Unless you tell Outlook NOT to use Word, at which point it will use its own
internal editor, which is most likely based on IE functionality. Just for
completeness....
Nobody
> If ? is encoded, what does it mean in terms of what I need to do
> before I send the email ?
A lot of things, like starting 20 threads, once per week on average, like
for example, why the following line prints 8250 in a US-English system
instead of 155?
Debug.Print AscW(Chr(155))
See also this post and the sample in it:
http://groups.google.com/group/microsoft.public.vb.general.discussion/msg/372001f97c1ab0f6
Or read a book about internationalization, or just use Outlook or your email
server auto forwarding feature. This is not a simple task as it might appear
to be.
fniles
seen the answer to this question, and now my boss wants to know the
answer to this question
On my machine (uses Outlook 2003) I can't see the ► in my Outlook if
the email is sent from my program (which is also on my machine).
If I sent the email from my program to another machine that can view
the ► in their Outlook, then, I forward that email from that machine
to my machine, and now I
can see the ► in my Outlook.
Why is that ?
Thank you
On Oct 18, 11:11 am, "Nobody" <nob...@nobody.com> wrote:
> "fniles" <fiefie.ni...@gmail.com> wrote in message
>
> news:9a133f8c-4925-4569...@w19g2000yqb.googlegroups.com...
>
> > If ? is encoded, what does it mean in terms of what I need to do
> > before I send the email ?
>
> A lot of things, like starting 20 threads, once per week on average, like
> for example, why the following line prints 8250 in a US-English system
> instead of 155?
>
> Debug.Print AscW(Chr(155))
>
> See also this post and the sample in it:
>
> http://groups.google.com/group/microsoft.public.vb.general.discussion...
fniles
forward the emails:
- The originator of the email must be a name that we can control
- All receipients of the email have to be blind copied they cannot see
the distribution list
- They do not want it to look like a forwarded message
- The logo has to appear and if it is forwarded from outside without
our program they cannot see the logo
On Oct 18, 11:11 am, "Nobody" <nob...@nobody.com> wrote:
> "fniles" <fiefie.ni...@gmail.com> wrote in message
>
> news:9a133f8c-4925-4569...@w19g2000yqb.googlegroups.com...
>
> > If ? is encoded, what does it mean in terms of what I need to do
> > before I send the email ?
>
> A lot of things, like starting 20 threads, once per week on average, like
> for example, why the following line prints 8250 in a US-English system
> instead of 155?
>
> Debug.Print AscW(Chr(155))
>
> See also this post and the sample in it:
>
> http://groups.google.com/group/microsoft.public.vb.general.discussion...
Nobody
> Why is that ?
Because Outlook on the other machine saw an error, and corrected it.
Seriously, if you fix this issue, you would feel that you fixed all problems
only to find out later that there are other problems that you need to fix.
Unless your boss wants to wait several months, I suggest that you use one of
the ready solutions.
Jeff Johnson
> On my machine (uses Outlook 2003) I can't see the ? in my Outlook if
> the email is sent from my program (which is also on my machine).
> If I sent the email from my program to another machine that can view
> the ? in their Outlook, then, I forward that email from that machine
> to my machine, and now I
> can see the ? in my Outlook.
Let me see if I follow you.
Scenario #1:
1) Somehow you generate an original message which has the triangle bullet
and you send it to your VB program (or the inbox that your VB program
monitors).
2) The VB program forwards the message to you.
3) You cannot see the triangle bullet in Outlook 2003, instead you see the
text "–" where the bullet should be.
Scenario #2:
1) Same as scenario #1.
2) The VB programs forwards the message to someone else.
3) That new someone CAN see the triangle bullet in his/her Outlook.
4) That someone forwards the message to you.
5) Now YOU can see the triangle bullet in your Outlook.
If those two scenarios are correct, then something REALLY weird is going on
here. I would expect that NO ONE would be able to see the bullet after your
program forwards the message, but if you're saying some can and some can't
you've got a lot more research to do.
If those two scenarios are NOT correct, can you please do what I did and
give us a step-by-step breakdown of what's happening?
fniles
generate the original emal that has the triangle bullet, some body
else did that.
My VB program then reads that email from a POP 3 server.
That's why my company kept asking me why ?
If the Outlook can't see the triangle bullet, it won't be able to do
that no matter what.
When I told them because that machine doesn't have that font, they
ask, why then on scenario #2 after the email is forwarded to me, I can
see the triangle bulle ?
I have no explanation to give.
Any suggestion ?
On Oct 18, 4:26 pm, "Jeff Johnson" <i....@enough.spam> wrote:
> "fniles" <fiefie.ni...@gmail.com> wrote in message
fniles
> > to be.- Hide quoted text -
@nomail.afraid.org FromTheRafters
making the differences (inconsistancies)?
Are the configurations homogeneous amongst the users with the "same"
software?
Are escape characters being consumed when parsing in some configurations but
not in the others?
"fniles" <fiefie...@gmail.com> wrote in message
news:d79b4eca-6fc3-4770...@l8g2000yql.googlegroups.com...
Those clients in my company that can't read ? in their Outlook, it
looks like by the time the email reach them, the ? was converted to
–.
But the weird thing is if through my VB program I send the email to a
client that can see the arrow fine like ? (either an Outlook client or
gmail), then I forward that email to that other client that can't read
the ? in the email sent from the program, now that client can read the
? fine.
So, if that client doesn't have the glyph or font, how could he see
the ? fine when the email is forwarded from another client that can
Nobody
> >Because Outlook on the other machine saw an error, and corrected it.
> Then, why on Jeff Johnson scenario #1, Outlook didn't correct it ?
It's hard to tell because there are a lot of variables. You could try this
software to view what's actually being sent and received so you can tell
what's happening:
http://en.wikipedia.org/wiki/Wireshark
Nobody
clearly. However, it sounds like that you need a newsletter type of
software. Here is a free and open source one:
Make sure that you click on "Service & Support", and check the video
tutorials, FAQ, and the Wiki.
"fniles" <fiefie...@gmail.com> wrote in message
news:8adf4b74-d304-4043...@t20g2000yqa.googlegroups.com...
Cor
Your kind of problems have mostly to do with the used code table by the User
(he/she seldom does that so in the Western Europe language area of the world
it is mostly standard 1252) on modern Windows systems.
In older systems it is often in the Western Europe culture area for English
437 while for other languages what is called International (850) with the
exception of Dutch which can be 850 or 437 (Because some strange
misunderstandings at Microsoft Redmond where is the idea that Dutch uses
another character table than English).
In Windows 95 this is a little bit strange to set because it has to be done
at the keyboard. In the other Windows versions (not 3.x) it is in the
language settings.
For information about that see these tables and than all above the 7 bit
ASCII part, which is for all tables the same.
http://en.wikipedia.org/wiki/Windows-1252
http://en.wikipedia.org/wiki/Code_page_850
I hope this helps somehow
Cor
"fniles" wrote in message
news:cee40611-db83-48c0...@a36g2000yqc.googlegroups.com...
Using VB6, I am sending an HTML email using SMTP.
I am having a problem when sending some characters (like a bullet
point that looks like an arrow) thru email that's received in
Outlook.
The weird thing is some Outlook client can see the arrow fine, some
can not.
My Outlook 2003 used to be able to see the arrow ok, but now it
doesn't.
Some Outlook 2007 can see it ok, some can't.
I can see the arrow fine in Gmail.
This is the character that we are having a problem with:
►
That arrow character becomes this in some of the Outlook client:
–
Thank you for your help.
This is my code:
Set poSendMail = New clsSendMail
poSendMail.SMTPHost = "a.com"
poSendMail.UserName = "a...@a.com"
poSendMail.Password = "mypwd"
poSendMail.UseAuthentication = True
poSendMail.delimiter = ";"
poSendMail.AsHTML = True
poSendMail.From = "mye...@mycom.com"
poSendMail.FromDisplayName = "a"
poSendMail.RecipientDisplayName = "fiefie"
poSendMail.Recipient = "m...@mycom.com;mye...@gmail.com"
poSendMail.Subject = "test"
poSendMail.Message = sEmail -> this contains HTML code below
poSendMail.Send
Set poSendMail = Nothing
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:v =
"urn:schemas-microsoft-com:vml" xmlns:o =
"urn:schemas-microsoft-com:office:office" xmlns:w =
"urn:schemas-microsoft-com:office:word" xmlns:ns0 =
"http://www.w3.org/1999/XSL/Format"><HEAD>
<META content="text/html; charset=utf-8" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18928"><!--[if !mso]>
<STYLE>v\:* {
BEHAVIOR: url(#default#VML)
}
o\:* {
BEHAVIOR: url(#default#VML)
}
w\:* {
BEHAVIOR: url(#default#VML)
}
.shape {
BEHAVIOR: url(#default#VML)
}
</STYLE>
<![endif]-->
<STYLE>@font-face {
font-family: Trebuchet MS;
}
@font-face {
font-family: Arial Rounded MT Bold;
}
@page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.25in 1.0in
1.25in; }
P.MsoNormal {
MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; FONT-SIZE: 12pt
}
LI.MsoNormal {
MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; FONT-SIZE: 12pt
}
DIV.MsoNormal {
MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; FONT-SIZE: 12pt
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: blue; TEXT-DECORATION: underline
}
P {
FONT-FAMILY: "Times New Roman"; MARGIN-LEFT: 0in; FONT-SIZE: 12pt;
MARGIN-RIGHT: 0in; mso-margin-top-alt: auto; mso-margin-bottom-alt:
auto
}
SPAN.EmailStyle20 {
FONT-FAMILY: Arial; COLOR: navy; mso-style-type: personal-reply
}
DIV.Section1 {
page: Section1
}
</STYLE>
</HEAD>
<BODY lang=EN-US link=blue vLink=blue>
<DIV dir=ltr align=left><FONT size=2 face=Arial></FONT> </DIV>
<DIV class=Section1>
<TABLE style="WIDTH: 100%; BORDER-COLLAPSE: collapse"
class=MsoNormalTable
border=0 cellSpacing=0 cellPadding=0 width="100%">
<TBODY>
<TR>
<TD
style="PADDING-BOTTOM: 0in; PADDING-LEFT: 0in; PADDING-RIGHT: 0in;
PADDING-TOP: 0in"
colSpan=3>
<TABLE style="WIDTH: 100%; BORDER-COLLAPSE: collapse"
class=MsoNormalTable
border=0 cellSpacing=0 cellPadding=0 width="100%">
<TBODY>
<TR>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; WIDTH:
80%; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt"
width="80%" colSpan=2>
<TABLE
style="BORDER-BOTTOM: medium none; BORDER-LEFT: medium
none; WIDTH: 19%; BORDER-COLLAPSE: collapse; BACKGROUND: red; BORDER-
TOP: medium none; BORDER-RIGHT: medium none"
class=MsoNormalTable border=1 cellSpacing=0 cellPadding=0
width="19%" bgColor=red>
<TBODY>
<TR>
<TD
style="BORDER-BOTTOM: #111111 1pt inset; BORDER-LEFT:
#111111 1pt inset; PADDING-BOTTOM: 0in; PADDING-LEFT: 0in; WIDTH:
100%; PADDING-RIGHT: 0in; BORDER-TOP: #111111 1pt inset; BORDER-RIGHT:
#111111 1pt inset; PADDING-TOP: 0in"
width="100%">
<P class=MsoNormal><A name=top></A><EM><B><I><FONT
color=white
size=2 face=Arial><SPAN
style="FONT-FAMILY: Arial; COLOR: white; FONT-SIZE:
10pt; FONT-WEIGHT: bold">Not
to be outside
a</SPAN></FONT></I></B></EM><o:p></o:p></P></TD></
TR></TBODY></TABLE>
<P style="MARGIN-BOTTOM: 12pt" class=MsoNormal><FONT
size=3
face="Times New Roman"><SPAN
style="FONT-SIZE: 12pt"><BR><BR></SPAN></FONT><B><FONT
face="Trebuchet MS"><SPAN
style="FONT-FAMILY: 'Trebuchet MS'; FONT-WEIGHT:
bold"><o:p></o:p></SPAN></FONT></B></P>
<P style="TEXT-ALIGN: center" class=MsoNormal
align=center><B><FONT
size=5 face="Trebuchet MS"><SPAN
style="FONT-FAMILY: 'Trebuchet MS'; FONT-SIZE: 18pt; FONT-
WEIGHT: bold">a
Solutions: October 14,
2010</SPAN></FONT></B><B><FONT face="Trebuchet MS"><SPAN
style="FONT-FAMILY: 'Trebuchet MS'; FONT-WEIGHT: bold">
<o:p></o:p></SPAN></FONT></B></P></TD>
<TD
style="BORDER-BOTTOM: medium none; BORDER-LEFT: medium none;
PADDING-BOTTOM: 0in; PADDING-LEFT: 0in; PADDING-RIGHT: 0in; BORDER-
TOP: medium none; BORDER-RIGHT: medium none; PADDING-TOP: 0in"
width=21>
<P class=MsoNormal> </P></TD></TR>
<TR>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; WIDTH:
80%; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt"
width="80%">
<P style="TEXT-ALIGN: center" align=center><A
name=thetop><FONT
size=3 face="Arial Rounded MT Bold"><SPAN
style="FONT-FAMILY: 'Arial Rounded MT Bold'; FONT-SIZE:
12pt"><BR></SPAN></FONT></A><IMG
border=0 hspace=0 alt=""
src=cid:alogo.JPG><o:p></o:p></P></TD>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; WIDTH:
20%; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt"
width="20%">
<P style="TEXT-ALIGN: right" align=right><FONT size=2
face=Arial><SPAN style="FONT-FAMILY: Arial; FONT-SIZE:
10pt"><A
href="a.htm">Archive</A>
<BR><A
href="mailto:a...@a.com?subject=Feedback%20about%20a%20Solar
%20Solutions%20a%20Up">Feedback
</A><BR><A
href="mailto:a...@a.com?subject=a%20Solar%20Solutions%20a%20Up
%20Subscription%20Request">Subscribe
</A><BR><A
href="mailto:a...@a.com?subject=Unsubscribe%20from%20a%20Solar
%20Solutions%20a%20Up">Unsubscribe
</A><BR><A
href="a.htm">a
Search</A> </SPAN></FONT><o:p></o:p></P></TD>
<TD
style="BORDER-BOTTOM: medium none; BORDER-LEFT: medium none;
PADDING-BOTTOM: 0in; PADDING-LEFT: 0in; PADDING-RIGHT: 0in; BORDER-
TOP: medium none; BORDER-RIGHT: medium none; PADDING-TOP: 0in"
width=21>
<P class=MsoNormal> </P></TD></TR>
<TR>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; WIDTH:
200%; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt"
width="200%" colSpan=2>
<TABLE style="WIDTH: 100%; BORDER-COLLAPSE: collapse"
class=MsoNormalTable border=0 cellSpacing=0 cellPadding=0
width="100%">
<TBODY>
<TR>
<TD
style="PADDING-BOTTOM: 0in; PADDING-LEFT: 0in; WIDTH:
50%; PADDING-RIGHT: 0in; PADDING-TOP: 0in"
vAlign=top width="50%">
<P class=MsoNormal><B><FONT color=#ffa620 size=3
face="Trebuchet MS"><SPAN
style="FONT-FAMILY: 'Trebuchet MS'; COLOR: #ffa620;
FONT-SIZE: 12pt; FONT-WEIGHT: bold">a
Information</SPAN></FONT></B>
<o:p></o:p></P>
<TABLE class=MsoNormalTable border=0 cellPadding=0>
<TBODY>
<TR>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT:
0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt"
vAlign=top>
<P class=MsoNormal><FONT color=blue size=2
face=Arial><SPAN
style="FONT-FAMILY: Arial; COLOR: blue; FONT-
SIZE: 10pt">► <o:p></o:p></SPAN></FONT></P></TD>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT:
0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt"
vAlign=top>
<P class=MsoNormal><FONT color=blue size=2
face=Arial><SPAN
style="FONT-FAMILY: Arial; COLOR: blue; FONT-
SIZE: 10pt"><A
href="#347114442_Customers">1. Best Rank
Teams Up
With ASES To Enlighten The Solar Energy
Industry</A><o:p></o:p></SPAN></FONT></P></
TD></TR></BODY></HTML>
Jeff Johnson
> Yes, those 2 scenarios are correct, with the exeption that I do not
> generate the original emal that has the triangle bullet, some body
> else did that.
> My VB program then reads that email from a POP 3 server.
Let's go this route, if you have time.
1) Install Outlook Express (if it isn't already) and set up an account
pointing to the POP server and the inbox where your program gets these
messages from.
2) In the Properties dialog for that account, go to the Advanced tab and
check the box that says "Leave a copy of messages on the server."
3) Get the admin to set up a second account just for you. This process won't
be of much use if you can't get this to happen.
4) Turn off your VB program.
5) Generate one of these messages.
6) Go to the "main" inbox and open the message. Hit Ctrl+F3. This will open
a Message Source window with the raw RFC822 message text.
7) Copy the entire text from the Message Source window and paste it into a
text editor.
8) Replace any part of the text that you consider sensitive with a bunch of
x's. For example, change email addresses to xxx...@xxxxxxx.com.
9) Copy and paste the resulting text into a reply to this thread. Be sure to
indicate that this is an original message.
10) Turn your VB program on and have it forward the message to the new
account you had created in step 3.
11) Repeat steps 6 - 9 (this time going to the new inbox instead of the main
one) and post the forwarded text. Again, indicate it as such in your reply.
We'll go from there.
Tony Toews
<fiefie...@gmail.com> wrote:
>That arrow character becomes this in some of the Outlook client:
So use a hyphen.
Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
fniles
I will try it and post the result here.
Thanks !
On Oct 19, 9:05 am, "Jeff Johnson" <i....@enough.spam> wrote:
> "fniles" <fiefie.ni...@gmail.com> wrote in message
fniles
>Are the configurations homogeneous amongst the users with the "same" software?
Are you referring to the Outlook configurations ?
>Are escape characters being consumed when parsing in some configurations but not in the others?
What did you mean by this ?
On Oct 18, 5:08 pm, "FromTheRafters" <erratic @nomail.afraid.org>
wrote:
> Maybe it is "Content-Transfer-Encoding" choices (configuration) that is
> making the differences (inconsistancies)?
>
> Are the configurations homogeneous amongst the users with the "same"
> software?
>
> Are escape characters being consumed when parsing in some configurations but
> not in the others?
>
> "fniles" <fiefie.ni...@gmail.com> wrote in message
> > <SPAN CLASS="Bullet"> • </SPAN>- Hide quoted text -
fniles
We will try that.
Thanks
On Oct 18, 8:48 pm, "Nobody" <nob...@nobody.com> wrote:
> "fniles" <fiefie.ni...@gmail.com> wrote in message
@nomail.afraid.org FromTheRafters
Thank you.
>Are the configurations homogeneous amongst the users with the "same"
>software?
Are you referring to the Outlook configurations ?
***
Yes, with all other things being equal, you would expect consistent results.
Since your results aren't consistent, perhaps user choices have crept in to
make things less equal.
***
>Are escape characters being consumed when parsing in some configurations
>but not in the others?
What did you mean by this ?
***
When the client parses the data, some characters may be considered "special"
and consumed. When a special character is meant to pass through without
being consumed, it has to be tagged with an escape character so that the
parser knows not to consume it (for instance if it was meant to be consumed
later by the HTML rendering engine in the client.
I'm not saying that I know the answer, but it might help you to troubleshoot
if you ensure that all the clients (sending and receiving) are configured
alike. I don't think (based on your description of symptoms) that your Man
In The Middle program is responsible for the inconsistencies, so it *must*
be your Outlook clients.
***
[...]
DAS
discussions...
DAS
--
To reply directly replace 'nospam' with 'schmetterling'
--
"Tony Toews" <tto...@telusplanet.net> wrote in message
news:3lvrb6hiu1esvguc7...@4ax.com...
[...]
Jeff Johnson
news:i9pmsr$v6v$1...@news.eternal-september.org...
>> So use a hyphen.
> THAT is too easy and does not lead to any further enjoyable detailed
> discussions...
Not to mention that the OP has stated that he's not in control of the
original message and needs to preserve it as-is.
Tony Toews
wrote:
>>> So use a hyphen.
>
>> THAT is too easy and does not lead to any further enjoyable detailed
>> discussions...
>
>Not to mention that the OP has stated that he's not in control of the
>original message and needs to preserve it as-is.
Details, details. <waving hands>
Guy Gorton
<tto...@telusplanet.net> wrote:
>Details, details. <waving hands>
>
>Tony
Glad you chipped in to this thread. I have been looking for someone
with Access expertise which your sig suggests you have.
In its simplest terms, the problem is that I have a large database on
Paradox. It works beautifully and I am amazed that the system loads
on to new Windows versions from the old 3 1/2 inch discs, so far
without problems, but that cannot last!
Main database with some 12,000 records, a number of related files,
lots of queries, some reports.
I have 2 or 3 smaller applucations on Paradox as well, but they are
not as important.
Is there a way of transferring the definitions to Access and the data?
Always assuming, of course, that Access is a relational database
engine.
TIA
Guy Gorton
Nobody
news:5hp2c6d160cjino64...@4ax.com...
> Glad you chipped in to this thread. I have been looking for someone
> with Access expertise which your sig suggests you have.
> In its simplest terms, the problem is that I have a large database on
> Paradox. It works beautifully and I am amazed that the system loads
> on to new Windows versions from the old 3 1/2 inch discs, so far
> without problems, but that cannot last!
> Main database with some 12,000 records, a number of related files,
> lots of queries, some reports.
> I have 2 or 3 smaller applucations on Paradox as well, but they are
> not as important.
> Is there a way of transferring the definitions to Access and the data?
> Always assuming, of course, that Access is a relational database
> engine.
I just checked with Access 2002, and one of the file formats that it can
open is Paradox. You can also access the data directly from ADO, see "Open
Paradox" in this article:
HOW TO: Use Jet OLE DB Provider 4.0 to Connect to ISAM Databases
http://support.microsoft.com/default.aspx?scid=kb;en-us;326548
From VB, you can use ADO's OpenSchema method to retrieve the list of
databases(adSchemaCatalogs), tables(adSchemaTables), and
fields(adSchemaColumns). I am not sure if it will work with Paradox
databases. See "OpenSchema method [ADO]" in MSDN, which includes VB sample.
You may also want to check this article:
How To Use the ADO OpenSchema Method in Visual Basic
http://support.microsoft.com/kb/186246
Dee Earley
VB6 comes with ODBC drivers for paradox and access (among many others)
so you can use that at the least to copy it.
Access may even have an import form a data source feature.
Next time however, try starting a new thread and asking in relevant
groups rather than hijacking a completely unrelated conversation.
--
Dee Earley (dee.e...@icode.co.uk)
i-Catcher Development Team
iCode Systems
(Replies direct to my email address will be ignored.
Please reply to the group.)
Jeff Johnson
news:5hp2c6d160cjino64...@4ax.com...
> Glad you chipped in to this thread. I have been looking for someone
> with Access expertise which your sig suggests you have.
THREADJACK!!
Tony Toews
<is.guy...@at.virgin.net> wrote:
>Paradox. It works beautifully and I am amazed that the system loads
>on to new Windows versions from the old 3 1/2 inch discs, so far
>without problems, but that cannot last!
Frequently MS products installed from floppies could be loaded onto a
CD or hard drive in folders named Disk1, Disk2, Disk3, etc. Or maye
the disks had those subfolders on them. Then when you ran the setup
from the first Disk1, or maybe it was in the root folder, I can't
recall now, the setup would install from all the subfolders. Thus you
no longer needed to have floppies lying around.
>Is there a way of transferring the definitions to Access and the data?
You've already got some answers. I have a vague memory that Access
2010 no longer supports Paradox.
>Always assuming, of course, that Access is a relational database
>engine.
Some would disagree but yes, Jet, the default database engine of
Access, is fully relational.
Guy Gorton
wrote:
>"Guy Gorton" <is.guy...@at.virgin.net> wrote in message
You are too kind.
Guy Gorton
Guy Gorton
<dee.e...@icode.co.uk> wrote:
>On 22/10/2010 11:37, Guy Gorton wrote:
>> On Thu, 21 Oct 2010 15:08:00 -0600, Tony Toews
>> <tto...@telusplanet.net> wrote:
>>
>>
>>> Details, details.<waving hands>
>>>
>>> Tony
>>
>> Glad you chipped in to this thread. I have been looking for someone
>> with Access expertise which your sig suggests you have.
>> In its simplest terms, the problem is that I have a large database on
>> Paradox. It works beautifully and I am amazed that the system loads
>> on to new Windows versions from the old 3 1/2 inch discs, so far
>> without problems, but that cannot last!
>> Main database with some 12,000 records, a number of related files,
>> lots of queries, some reports.
>> I have 2 or 3 smaller applucations on Paradox as well, but they are
>> not as important.
>> Is there a way of transferring the definitions to Access and the data?
>> Always assuming, of course, that Access is a relational database
>> engine.
>
>VB6 comes with ODBC drivers for paradox and access (among many others)
>so you can use that at the least to copy it.
>Access may even have an import form a data source feature.
>
Thanks for your help.
>Next time however, try starting a new thread and asking in relevant
>groups rather than hijacking a completely unrelated conversation.
The unrelated bit was the poster's sig - and a very helpful one. I
presumed that we would go off to some other group, but how to find the
relevant one is not straightforward..
Guy Gorton
Viken Cerpovna
Not sure which version of Paradox and Access you are using but there is an
import feature in Access that enables you to either create a linked table in
the database for the Paradox database, or, you can import the contents and
create a native table in Access. I have 2007 and the feature is located on
the External Data ribbon (click on the More option and you will see Paradox
in the list).
Guy Gorton
wrote:
Thanks. I have Paradox 5 and Access 2003. I have previously looked
for this kind of facility, but failed to find it. Will try again.
Guy Gorton
fniles
Sorry, it takes a long time, but they agree not to put the arrow in
the email anymore, so we don't have that problem anymore, but there
are other characters that look ok in some email client software (like
in Gmail), but don't look ok in other email client software (like in
Outlook 2007).
When I go to Message Source window (# 6 & 7) for the original email,
it's in base64 (like ZyAmIEZ....), and it's pretty long to copy and
paste it on this post.
The forwarded email is not in base64, but it's also pretty long to
copy and paste it on this post.
Is there a way for me to attach a file here ?
The problem that I have right now is this:
The characters
“We
became
“We
3 . US Eastman To Expand 'Tritan' Capacity By End-2011
$7m [€5m]
became
$7m [€5m]
Thank you.
On Oct 19, 9:05 am, "Jeff Johnson" <i....@enough.spam> wrote:
> "fniles" <fiefie.ni...@gmail.com> wrote in message
Nobody
means that it's encoded in UTF-8.
"fniles" <fiefie...@gmail.com> wrote in message
news:1bbebd35-1d85-474e...@j33g2000vbb.googlegroups.com...
Hi,
Sorry, it takes a long time, but they agree not to put the arrow in
the email anymore, so we don't have that problem anymore, but there
are other characters that look ok in some email client software (like
in Gmail), but don't look ok in other email client software (like in
Outlook 2007).
When I go to Message Source window (# 6 & 7) for the original email,
it's in base64 (like ZyAmIEZ....), and it's pretty long to copy and
paste it on this post.
The forwarded email is not in base64, but it's also pretty long to
copy and paste it on this post.
Is there a way for me to attach a file here ?
The problem that I have right now is this:
The characters
�We
became
“We
3 . US Eastman To Expand 'Tritan' Capacity By End-2011
$7m [�5m]
became
$7m [€5m]
Thank you.
fniles
The problem that I have is
“
became
“
and
€
became
€
On Nov 3, 4:00 pm, "Nobody" <nob...@nobody.com> wrote:
> Usually, but not always, when some characters expands to 3 characters, it
> means that it's encoded in UTF-8.
>
> "fniles" <fiefie.ni...@gmail.com> wrote in message
>
> news:1bbebd35-1d85-474e...@j33g2000vbb.googlegroups.com...
> Hi,
> Sorry, it takes a long time, but they agree not to put the arrow in
> the email anymore, so we don't have that problem anymore, but there
> are other characters that look ok in some email client software (like
> in Gmail), but don't look ok in other email client software (like in
> Outlook 2007).
> When I go to Message Source window (# 6 & 7) for the original email,
> it's in base64 (like ZyAmIEZ....), and it's pretty long to copy and
> paste it on this post.
> The forwarded email is not in base64, but it's also pretty long to
> copy and paste it on this post.
> Is there a way for me to attach a file here ?
>
> The problem that I have right now is this:
> The characters
> “We
> became
> “We
>
> 3 . US Eastman To Expand 'Tritan' Capacity By End-2011
> $7m [€5m]
> became
> $7m [€5m]
>
> Thank you.
Raymond Schmit
<fiefie...@gmail.com> wrote:
>Hi, sorry, but what did you mean by expand to 3 characters ?
>The problem that I have is
>�
>became
>“
>
>and
>�
>became
>€
>
I show you what i see in your post (inserting an extra space)
>The problem that I have is
> �
>became
> � � �
>
>and
> �
>became
> � � �
>
The 3 characters are the utf8 representation of the single iso
character.
Nobody
>Hi, sorry, but what did you mean by expand to 3 characters ?
>The problem that I have is
> �
> became
These 3 characters in Hex are:
� = E2
� = 80
� = 9C
E2 80 9C
Or in Binary:
1110 0010 1000 0000 1001 1100
From "UTF-8 bytes" column here:
http://en.wikipedia.org/wiki/UTF-8#Description we could reconstruct the
Unicode-16 character code. It looks like in the range of U+0800 to U+FFFF.
1110 zzzz = E2 = 1110 0010
10yy yyyy = 80 = 1000 0000
10xx xxxx = 9C = 1001 1100
So,
zzzz = 0010
yy yyyy = 00 0000
xx xxxx = 01 1100
The original code is:
zzzzyyyy yyxxxxxx = 0010 0000 0001 1100
So it's &H201C in Unicode. Entering "201C" at the search box at the top of
this page will show you what it looks like, and the character name:
http://www.unicode.org/charts/
Here is the link to the PDF:
http://www.unicode.org/charts/PDF/U2000.pdf
If you go to page 2 of the PDF, it shows that it's name is "Left double
quotation mark".
> and
> �
> became
> €
Similarly, these 3 characters in Hex are:
� = E2
� = 82
� = AC
E2 82 AC
Or in Binary:
1110 0010 1000 0010 1010 1100
This too looks like in the range of U+0800 to U+FFFF.
1110 zzzz = E2 = 1110 0010
10yy yyyy = 82 = 1000 0010
10xx xxxx = AC = 1010 1100
zzzz = 0010
yy yyyy = 00 0010
xx xxxx = 10 1100
The original code is:
zzzzyyyy yyxxxxxx = 0010 0000 1010 1100
So it's &H20AC in Unicode. Entering "20AC" at the search box at the top of
the page above shows that its name is "Euro sign".
Obviously, you can write a VB function for this, but others have already
done so. Here is an API based one:
http://groups.google.com/group/microsoft.public.vb.general.discussion/msg/21d8ec60ad5cfd23
fniles
This is in the email that I read
<META content="text/html; charset=UTF-8" http-equiv=Content-Type>
Here are more information:
The original email that I read is in base64.
I use the Function DecodeBase64String from EVICT_POP3.dll to decode
the base64, I am including its code below.
After that function, when I trace my program, and I do
?mid(sraw,instr(1,sraw,"roughly $7m"),20)
it returns
roughly $7m [€5m]
instead of
roughly $7m [€5m]
If I write sraw to a file, it will show as
roughly $7m [€5m]
When the email gets to the Outlook clients, some clients see them as
$7m [€5m], but some see them as $7m [€5m], even though both clients
are using the exact same version of Outlook 2007.
What do you suggest I do ?
How do I use the function FromUTF8Buf (from the API that you included)
to fix my problem ?
Thanks again.
Public Function DecodeBase64String(str2Decode As String) As String
' Coerce 4 base 64 encoded bytes into 3 decoded bytes by converting
4, 6 bit
' values (0 to 63) into 3, 8 bit values. Transform the 8 bit value
into its
' ascii character equivalent. Stop converting at the end of the
input string
' or when the first '=' (equal sign) is encountered.
533 On Error GoTo ErrorHandler
534 Dim lPtr As Long
535 Dim iValue As Integer
536 Dim iLen As Integer
537 Dim iCtr As Integer
538 Dim Bits(1 To 4) As Byte
539 Dim strDecode As String
540 Dim lPtr2 As Long
' Clean it up and create the destination buffer
541 str2Decode = Replace(str2Decode, vbCrLf, "")
542 lPtr2 = 0
543 strDecode = String$(Len(str2Decode) * 3 / 4 + 3, " ")
' for each 4 character group....
544 For lPtr = 1 To Len(str2Decode) Step 4
545 iLen = 4
546 For iCtr = 0 To 3
' retrive the base 64 value, 4 at a time
547 iValue = InStr(1, BASE64CHR, Mid$(str2Decode, lPtr +
iCtr, 1), vbBinaryCompare)
548 Select Case iValue
' A~Za~z0~9+/
Case 1 To 64: Bits(iCtr + 1) = iValue - 1
' =
549 Case 65
550 iLen = iCtr
551 Exit For
' not found
552 Case 0
553 Exit Function
554 End Select
555 Next iCtr
' convert the 4, 6 bit values into 3, 8 bit values
556 Bits(1) = Bits(1) * &H4 + (Bits(2) And &H30) \ &H10
557 Bits(2) = (Bits(2) And &HF) * &H10 + (Bits(3) And &H3C) \
&H4
558 Bits(3) = (Bits(3) And &H3) * &H40 + Bits(4)
' add the three new characters to the output string
559 For iCtr = 1 To iLen - 1
560 lPtr2 = lPtr2 + 1
561 Mid$(strDecode, lPtr2, 1) = Chr$(Bits(iCtr))
562 Next iCtr
563 Next lPtr
564 DecodeBase64String = Left$(strDecode, lPtr2)
565 Exit Function
On Nov 3, 8:26 pm, "Nobody" <nob...@nobody.com> wrote:
> "fniles" <fiefie.ni...@gmail.com> wrote in message
>
> news:81791232-b256-4283...@q18g2000vbm.googlegroups.com...
>
> >Hi, sorry, but what did you mean by expand to 3 characters ?
> >The problem that I have is
> > “
> > became
> > “
>
> These 3 characters in Hex are:
>
> â = E2
> € = 80
> œ = 9C
>
> E2 80 9C
>
> Or in Binary:
>
> 1110 0010 1000 0000 1001 1100
>
> From "UTF-8 bytes" column here:http://en.wikipedia.org/wiki/UTF-8#Descriptionwe could reconstruct the
> Unicode-16 character code. It looks like in the range of U+0800 to U+FFFF.
>
> 1110 zzzz = E2 = 1110 0010
> 10yy yyyy = 80 = 1000 0000
> 10xx xxxx = 9C = 1001 1100
>
> So,
>
> zzzz = 0010
> yy yyyy = 00 0000
> xx xxxx = 01 1100
>
> The original code is:
>
> zzzzyyyy yyxxxxxx = 0010 0000 0001 1100
>
> So it's &H201C in Unicode. Entering "201C" at the search box at the top of
> this page will show you what it looks like, and the character name:
>
> http://www.unicode.org/charts/
>
> Here is the link to the PDF:
>
> http://www.unicode.org/charts/PDF/U2000.pdf
>
> If you go to page 2 of the PDF, it shows that it's name is "Left double
> quotation mark".
>
> > and
> > €
> > became
> > €
>
> Similarly, these 3 characters in Hex are:
>
> â = E2
> ‚ = 82
> ¬ = AC
>
> E2 82 AC
>
> Or in Binary:
>
> 1110 0010 1000 0010 1010 1100
>
> This too looks like in the range of U+0800 to U+FFFF.
>
> 1110 zzzz = E2 = 1110 0010
> 10yy yyyy = 82 = 1000 0010
> 10xx xxxx = AC = 1010 1100
>
> zzzz = 0010
> yy yyyy = 00 0010
> xx xxxx = 10 1100
>
> The original code is:
>
> zzzzyyyy yyxxxxxx = 0010 0000 1010 1100
>
> So it's &H20AC in Unicode. Entering "20AC" at the search box at the top of
> the page above shows that its name is "Euro sign".
>
> Obviously, you can write a VB function for this, but others have already
> done so. Here is an API based one:
>
> http://groups.google.com/group/microsoft.public.vb.general.discussion...
Nobody
> Thank you for your reply.
> This is in the email that I read
> <META content="text/html; charset=UTF-8" http-equiv=Content-Type>
Are you including the above line in the email that you are sending?
> Here are more information:
> The original email that I read is in base64.
> I use the Function DecodeBase64String from EVICT_POP3.dll to decode
> the base64, I am including its code below.
> After that function, when I trace my program, and I do
> ?mid(sraw,instr(1,sraw,"roughly $7m"),20)
> it returns
> roughly $7m [€5m]
> instead of
> roughly $7m [�5m]
>
> If I write sraw to a file, it will show as
> roughly $7m [�5m]
If that what appears in the file, then somewhere in the process the text was
UTF-8 decoded. VB doesn't do that. How did you save the file?
> When the email gets to the Outlook clients, some clients see them as
> $7m [€5m], but some see them as $7m [�5m], even though both clients
> are using the exact same version of Outlook 2007.
If the META line above which tells the charset used is missing in when
sending to some clients, then the user would see "€" instead of "�".
When you send the emails, do you send them individually, or do you send one
email to multiple recipients?
> What do you suggest I do ?
> How do I use the function FromUTF8Buf (from the API that you included)
> to fix my problem ?
See the last few lines in that post to see how its used. However, if you are
decoding it to make some changes, then resend it, you need to encode the
result to UTF-8 by using ToUTF8Buf() before sending it.
Nobody
? instead of the euro sign. Here is the email again:
fniles wrote:
> Thank you for your reply.
> This is in the email that I read
> <META content="text/html; charset=UTF-8" http-equiv=Content-Type>
Are you including the above line in the email that you are sending?
> Here are more information:
> The original email that I read is in base64.
> I use the Function DecodeBase64String from EVICT_POP3.dll to decode
> the base64, I am including its code below.
> After that function, when I trace my program, and I do
> ?mid(sraw,instr(1,sraw,"roughly $7m"),20)
> it returns
> roughly $7m [?5m]
> instead of
> roughly $7m [5m]
>
> If I write sraw to a file, it will show as
> roughly $7m [5m]
If that what appears in the file, then somewhere in the process the text was
UTF-8 decoded. VB doesn't do that. How did you save the file?
> When the email gets to the Outlook clients, some clients see them as
> $7m [?5m], but some see them as $7m [5m], even though both clients
> are using the exact same version of Outlook 2007.
If the META line above which tells the charset used is missing in when
sending to some clients, then the user would see "?" instead of "".
When you send the emails, do you send them individually, or do you send one
email to multiple recipients?
> What do you suggest I do ?
> How do I use the function FromUTF8Buf (from the API that you included)
> to fix my problem ?
See the last few lines in that post to see how its used. However, if you are
fniles
> Are you including the above line in the email that you are sending?
>If that what appears in the file, then somewhere in the process the text was UTF-8 decoded. VB doesn't do that. How did you save the file?
Did you mean between the call POP3.DecodeBase64String and before I
sent the email the text was UTF-8 decoded ?
These are my codes:
sRaw = POP3.DecodeBase64String(Mid(sRaw, iStart, iEnd - iStart))
'At this point in the Immediate window ?mid(sraw,instr(1,sraw,"roughly
$7m"),20) returns "roughly $7m [€5m]"
Open App.Path & "\raw.txt" For Append As #4 'write to the file.
Print #4, sRaw
'The raw.txt file contains "roughly $7m [€5m]", not "roughly $7m
[€5m]"
Close #4
'Do you think by changing sRaw below I am decoding it ?
sRaw = Mid(sRaw, InStr(sRaw, "<"))
iix = InStr(sRaw, "src=" & Chr(34) & "cid:")
iIx2 = InStr(iix + 5, sRaw, Chr(34))
sCID = Mid(sRaw, iix, iIx2 - iix + 1)
sRaw = Replace(sRaw, sCID, "src=cologo.jpg")
poSendMail.Attachment = App.Path & "\cologo.JPG"
poSendMail.Message = sRaw
>When you send the emails, do you send them individually, or do you send one email to multiple recipients?
I send the same email to multiple recipients delimited by ";". The
email doesnt have Recipient, but it has BccRecipient and CcRecipient.
>See the last few lines in that post to see how its used. However, if you are decoding it to make some changes, then resend it, you need to encode the
>result to UTF-8 by using ToUTF8Buf() before sending it.
From looking at my code above, do you think I decoded the email ?
Did you mean before sending the email, I need to do the following
UTF8String = ToUTF8(sRaw)
poSendMail.Message = UTF8String
where sRaw contains the entire email ?
When I did that, the email looks bad in my Outlook 2007 (previously
the email was good on my Outlook 2007, but bad on another Outlook
2007):
Now I see
roughly $7m [€5m]
instead of
roughly $7m [€5m]
Thank you
On Nov 4, 12:15 pm, "Nobody" <nob...@nobody.com> wrote:
> fnileswrote:
> > Thank you for your reply.
> > This is in the email that I read
> > <METAcontent="text/html; charset=UTF-8" http-equiv=Content-Type>
>
> Are you including the above line in the email that you are sending?
>
> > Here are more information:
> > The original email that I read is in base64.
> > I use the Function DecodeBase64String from EVICT_POP3.dll to decode
> > the base64, I am including its code below.
> > After that function, when I trace my program, and I do
> > ?mid(sraw,instr(1,sraw,"roughly $7m"),20)
> > it returns
> > roughly $7m [€5m]
> > instead of
> > roughly $7m [ 5m]
>
> > If I write sraw to a file, it will show as
> > roughly $7m [ 5m]
>
> If that what appears in the file, then somewhere in the process the text was
> UTF-8 decoded. VB doesn't do that. How did you save the file?
>
> > When the email gets to the Outlook clients, some clients see them as
> > $7m [€5m], but some see them as $7m [ 5m], even though both clients
> > are using the exact same version of Outlook 2007.
>
> If theMETAline above which tells the charset used is missing in when
Nobody
encoding method just before sending.
http://home.in.tum.de/~jain/software/oe-quotefix/
Here is the email again. I hope that the euro sign shows up this time.
Nobody
>> <METAcontent="text/html; charset=UTF-8" http-equiv=Content-Type>
>> Are you including the above line in the email that you are sending?
> Yes
>
>> If that what appears in the file, then somewhere in the process the
>> text was UTF-8 decoded. VB doesn't do that. How did you save the
>> file?
> Did you mean between the call POP3.DecodeBase64String and before I
> sent the email the text was UTF-8 decoded ?
Please disregard that. I found out that Notepad is the one that does UTF-8
decoding. Perhaps it auto detects it. Use a Hex editor or a simpler text
viewer than Notepad! Perhaps a simple VB app with a TextBox. Here is a
sample code to duplicate the problem:
Option Explicit
Private Sub Form_Load()
Dim sRaw As String
sRaw = Chr(&HE2) & Chr(&H82) & Chr(&HAC)
Open "C:\raw.txt" For Append As #1
Print #1, sRaw
Close #1
End Sub
In a Hex editor I see:
E2 82 AC 0D 0A
In Notepad under XP, I see one character, the Euro sign.
> These are my codes:
> sRaw = POP3.DecodeBase64String(Mid(sRaw, iStart, iEnd - iStart))
> 'At this point in the Immediate window ?mid(sraw,instr(1,sraw,"roughly
> $7m"),20) returns "roughly $7m [�,�5m]"
> Open App.Path & "\raw.txt" For Append As #4 'write to the file.
> Print #4, sRaw
> 'The raw.txt file contains "roughly $7m [?5m]", not "roughly $7m
> [�,�5m]"
> Close #4
> 'Do you think by changing sRaw below I am decoding it ?
> sRaw = Mid(sRaw, InStr(sRaw, "<"))
> iix = InStr(sRaw, "src=" & Chr(34) & "cid:")
> iIx2 = InStr(iix + 5, sRaw, Chr(34))
> sCID = Mid(sRaw, iix, iIx2 - iix + 1)
> sRaw = Replace(sRaw, sCID, "src=cologo.jpg")
> poSendMail.Attachment = App.Path & "\cologo.JPG"
> poSendMail.Message = sRaw
>
>> When you send the emails, do you send them individually, or do you
>> send one email to multiple recipients?
> I send the same email to multiple recipients delimited by ";". The
> email doesnt have Recipient, but it has BccRecipient and CcRecipient.
>
>> See the last few lines in that post to see how its used. However, if
>> you are decoding it to make some changes, then resend it, you need
>> to encode the result to UTF-8 by using ToUTF8Buf() before sending
>> it.
> From looking at my code above, do you think I decoded the email ?
You did Base64 decoding, but you didn't do UTF-8 decoding, which is okay.
> Did you mean before sending the email, I need to do the following
> UTF8String = ToUTF8(sRaw)
> poSendMail.Message = UTF8String
> where sRaw contains the entire email ?
No. I assumed that you want to change the text in the email, which it
appears that you are not doing. If you want to change the text, and you are
adding or replacing characters in the range 128+, then you can do it in 3
steps:
1 - Do UTF-8 Decode.
2 - Change the text.
3 - Do UTF-8 Encode.
> When I did that, the email looks bad in my Outlook 2007 (previously
> the email was good on my Outlook 2007, but bad on another Outlook
> 2007):
> Now I see
> roughly $7m [�,�5m]
> instead of
> roughly $7m [?5m]
That's expected. Doing UTF-8 Encoding more than once will result on
different output each time if the input had characters in the range 128+.
fniles
UTF8String = ToUTF8(sRaw) ?
>I assumed that you want to change the text in the email, which it appears that you are not doing
I do replace the "cid:" with "src=cologo.jpg" in the email as shown
below, but this is not what you mean by "changing the text in the
email" ?
sRaw = Mid(sRaw, InStr(sRaw, "<"))
iix = InStr(sRaw, "src=" & Chr(34) & "cid:")
iIx2 = InStr(iix + 5, sRaw, Chr(34))
sCID = Mid(sRaw, iix, iIx2 - iix + 1)
sRaw = Replace(sRaw, sCID, "src=cologo.jpg")
>You did Base64 decoding, but you didn't do UTF-8 decoding, which is okay.
So, since I didn't do UTF-8 decoding, what causes some Outlook 2007
clients to see
roughly $7m [€5m]
as
roughly $7m [€5m]
?
How can I fix the problem so that all Outlook clients see the correct
characters ?
Thanks for your help.
On Nov 4, 1:54 pm, "Nobody" <nob...@nobody.com> wrote:
> fnileswrote:
> different output each time if the input had characters in the range 128+.- Hide quoted text -
>
> - Show quoted text -
Nobody
> So, I don't need to do
> UTF8String = ToUTF8(sRaw) ?
No you don't.
>> I assumed that you want to change the text in the email, which it
>> appears that you are not doing
> I do replace the "cid:" with "src=cologo.jpg" in the email as shown
> below, but this is not what you mean by "changing the text in the
> email" ?
You don't need to decode/modify/encode in this case, because all you are
replacing and adding in "cid:" is in the range of 0 to 127.
>> You did Base64 decoding, but you didn't do UTF-8 decoding, which is
>> okay.
> So, since I didn't do UTF-8 decoding, what causes some Outlook 2007
> clients to see
> roughly $7m [€5m]
> as
> roughly $7m [€5m]
> ?
>
> How can I fix the problem so that all Outlook clients see the correct
> characters ?
If both clients received the same single email that you are sending to both,
then this leaves one conclusion: It's Outlook settings, and IE version that
are different that cause the discrepancy. Run Regedit, and export this key
from the two computers, and compare the settings:
HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Outlook
Use the following free software to compare the two files:
fniles
It looks like the problem has something to do with the IE version.
Thanks for all your help !
On Nov 4, 1:39 pm, "Nobody" <nob...@nobody.com> wrote:
> fnileswrote:
> > So, I don't need to do
> > UTF8String = ToUTF8(sRaw) ?
>
> No you don't.
>
> >> I assumed that you want to change the text in the email, which it
> >> appears that you are not doing
> > I do replace the "cid:" with "src=cologo.jpg" in the email as shown
> > below, but this is not what you mean by "changing the text in the
> > email" ?
>
> You don't need to decode/modify/encode in this case, because all you are
> replacing and adding in "cid:" is in the range of 0 to 127.
>
> >> You did Base64 decoding, but you didn't do UTF-8 decoding, which is
> >> okay.
> > So, since I didn't do UTF-8 decoding, what causes some Outlook 2007
> > clients to see
> > roughly $7m [€5m]
> > as
> > roughly $7m [€5m]