SendObject - Email address truncates

[Guest]

Hello

This is my first post so please be kind.

I am using the Send Object (VB - A2K) to prepare and send some reports via email (Lotus Notes v5). The issue that confronts me is that when I execute the code everything goes as planned until the email addresses are populated

I am currently sending the email to two recipients (fields are set up as an array as a string), but the "m" of the ".com" is being truncated on one of the addresses. Please let me know if anyone has come across this before. Thank you.

 

[Bryan Reich [MSFT]]

A sample of code detailing what you are trying to do would be helpful. Any
chance you could post the snippet dealing with retrieving the emails, and
then the code using them when sending the email?
--
Bryan Reich
Microsoft Office
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of any included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

Hello,

This is my first post so please be kind.

I am using the Send Object (VB - A2K) to prepare and send some reports via

email (Lotus Notes v5). The issue that confronts me is that when I execute
the code everything goes as planned until the email addresses are populated.

I am currently sending the email to two recipients (fields are set up as

an array as a string), but the "m" of the ".com" is being truncated on one
of the addresses. Please let me know if anyone has come across this before.
Thank you.

 

[Bryan Reich [MSFT]]

Is this happening in all three reports?
Also, does this happen no matter how long or short the email names you pass
are? Is it the TO or the CC line that gets truncated?
--
Bryan

Here is the code:

Function audit_sap_missing_salary_review()

Dim sTo(10) As String

sTo(1) = "(e-mail address removed)"
sTo(2) = "(e-mail address removed)"


DoCmd.SendObject acSendReport, "HRDBO_audit_sap_missing_salary_review",

acFormatRTF, sTo(1), sTo(2), "", _

"HRDBO Audit - Missing Salary Review", "Please contact me with any

questions or concerns regarding this report."

DoCmd.SendObject acSendReport, "HRDHP_audit_sap_missing_salary_review",

acFormatRTF, sTo(1), sTo(2), "", _

"HRDHP Audit - Missing Salary Review", "Please contact me with any

questions or concerns regarding this report."

DoCmd.SendObject acSendReport, "HRFND_audit_sap_MISSING_SALARY_REVIEW",

acFormatRTF, sTo(1), sTo(2), "", _

"HRFND Audit - MISSING SALARY REVIEW", "Please contact me with any

questions or concerns regarding this report."

 

[Guest]

Hi Bryan

I have been performing some testing on this and I think the error occurs when I call this function multiple times. If I call it once or twice within the same routine, email addresses appear properly. When I call it three or more times (total of nine emails created), the email address truncates

The odd part is that it will will fluctuate between the cc: and to: addressees. On the seventh email the "m" is dropped off of the to:, on the eigth it is dropped off the cc:

I did some hunting on a Lotus newsgroup and it appears another person reported this problem with no response. Any ideas? Again, thank you for your time on this matter.

 

[Bryan Reich [MSFT]]

Matt,
Truly a bizzarre thing, but it appears the problem is related to something
odd going on in Lotus and not Access. I've set up what I think is your basic
scenario except that I'm not set up with Lotus but instead with Outlook. I
don't see any truncation when mailing repeated reports to Outlook. This may
be a question better addressed by people who have used Lotus and might be
able to help you work out a solution that works with that product. Sorry I
can't be more helpful.
--
Bryan
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of any included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

Hi Bryan,

I have been performing some testing on this and I think the error occurs

when I call this function multiple times. If I call it once or twice within
the same routine, email addresses appear properly. When I call it three or
more times (total of nine emails created), the email address truncates.

The odd part is that it will will fluctuate between the cc: and to:

addressees. On the seventh email the "m" is dropped off of the to:, on the
eigth it is dropped off the cc:.

I did some hunting on a Lotus newsgroup and it appears another person

reported this problem with no response. Any ideas? Again, thank you for
your time on this matter.

 

[Guest]

Thanks for looking into this for me.

I have developed a workaround (thanks to Tony Toew's code page) which bypasses the sendobject code and accomplishes the same goal by using calls to functions inheritant to Lotus Notes' Domino library.

By the way, this is an excellent forum for discussion and brainstorming. I look forward to using this tool in the future.

 

[Bryan Reich [MSFT]]

Glad you found a solution Matt. Tony's work is good stuff.
--
Bryan
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of any included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

Thanks for looking into this for me.

I have developed a workaround (thanks to Tony Toew's code page) which

bypasses the sendobject code and accomplishes the same goal by using calls
to functions inheritant to Lotus Notes' Domino library.

By the way, this is an excellent forum for discussion and brainstorming.

I look forward to using this tool in the future.