We have developed VBA add-in for Excel some time ago, which also sends
required data from add-in by email. Email function is based on MAPI (Active
X of VB6). - Everything was working fine (emails were going throuth
Outlooks/Outlook Express of various versions), until - .... people started
to use Outlook 2003. With it now ... emails from our add-in are stuck in the
Outbox and not going.
On a close inspection we discovered that email addresses of recipients are
embrased with apostrophs, i.e. '. Removing apostrophs
manually helps sending emails.
But we are confused why and how these apostrophs appear, and what is the
workaround.
Anybody has a clue / experience on this issue?
Thanks and regards.