ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Help with emails from Excel-add via Outlook 2003 (mistery apostrophs) (https://www.excelbanter.com/excel-programming/321483-help-emails-excel-add-via-outlook-2003-mistery-apostrophs.html)

qwer[_2_]

Help with emails from Excel-add via Outlook 2003 (mistery apostrophs)
 
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.




All times are GMT +1. The time now is 01:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com