Attachments get clobbered going through SMTP - Notes

I have a VBA routine that sends through SMTP an email with a small
Excel attachment with no macros. Everything works fine except the
attachment is clobbered somewhere along the way. When the user tries
to open the attachment, they receive an error message stating the file
could not be accessed, it is read only or is stored on a server that is
not responding. I've checked with our Network folks and it is not
related to any type of virus scanning. I've tried different files,
*.ZIP and *.DOC and all receive the same message. Detaching or saving
the document does no good. All of our SMTP mail is handled by a Notes
server.

Any thoughts?

Re: Attachments get clobbered going through SMTP - Notes

This is a MIME GnuPG-signed message. If you see this text, it means that
your E-mail or Usenet software does not support MIME signed messages.

--=_mimegpg-commodore.email-scan.com-24884-1111710395-0004
Content-Type: text/plain; format=flowed; charset="US-ASCII"
Content-Disposition: inline
Content-Transfer-Encoding: 7bit

Freebird writes:

> I have a VBA routine that sends through SMTP an email with a small
> Excel attachment with no macros.

I'm very sorry to hear that. That must be painful. Take two aspirins, and
call me in the morning.

> Everything works fine except the
> attachment is clobbered somewhere along the way. When the user tries
> to open the attachment, they receive an error message stating the file
> could not be accessed, it is read only or is stored on a server that is
> not responding. I've checked with our Network folks and it is not
> related to any type of virus scanning. I've tried different files,
> *.ZIP and *.DOC and all receive the same message. Detaching or saving
> the document does no good. All of our SMTP mail is handled by a Notes
> server.

Ouch. The good Lord above must be punishing for some awful sin of yours.
What did you do?

> Any thoughts?

Nobody who's serious about developing E-mail based applications will have
anything to do with Microsoft's shitware, whose primary purpose is really to
be an efficient virus propagation mechanism.

All of the above can be accomplished fairly easily using a simple script,
and a few rather straightforward tools in Linux or Unix. It is not
necessary to rely on mysterious inner workings of some convoluted ActiveX
control, whose source code you cannot examine to determine what's wrong, or
some similar shit.



--=_mimegpg-commodore.email-scan.com-24884-1111710395-0004
Content-Type: application/pgp-signature
Content-Transfer-Encoding: 7bit

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iD8DBQBCQ1q7x9p3GYHlUOIRAoj2AKCBjGTPRd4PitwexMrzJa+qQlgXqgCb BmnL
8WZ0kag9EehEp4yAudQrXyc=
=Pu5U
-----END PGP SIGNATURE-----

--=_mimegpg-commodore.email-scan.com-24884-1111710395-0004--

Re: Attachments get clobbered going through SMTP - Notes

> I have a VBA routine that sends through SMTP an email with a small
> Excel attachment with no macros. Everything works fine except the
> attachment is clobbered somewhere along the way. When the user tries
> to open the attachment, they receive an error message stating the file
> could not be accessed, it is read only or is stored on a server that is
> not responding.

I have no idea what that means. Just do 'less' on the mail file and take a
look at its construction. You should be able to see what has gone wrong by
comparing it to a regular UNIX email. For instance, are the MIME headers
destroyed? base64 encoded lines truncated? Line terminations messed up, LF
converted to CR LF perhaps?

--
Jem Berkes
Software design for Windows and Linux/Unix-like systems
http://www.sysdesign.ca/

Re: Attachments get clobbered going through SMTP - Notes

I suspect that what's actually happening is that your message contains a
link to the original file being sent - not an encoded copy of the file
itself. That's one of the reasons that I often use the free BLAT program to
send smtp mail from a windows application. I've used version 1.8.4 for
years with great success. I see that it's now an opensource project at
http://sourceforge.net/projects/blat and at V2.4.0

I also have a VB program that I wrote
that uses a database interface to receive a queue of mail to be sent -
http://www.floatingbear.ca/botdocs/ for more information. This works well
for sending larger amounts of mail - for example one company I deal with
uses it to send out their customer quotes on a monthly basis.

--
Andrew Butchart
andrew@floatingbear.ca


"Freebird" wrote in message
news:1111706680.321389.320980@z14g2000cwz.googlegroups.com.. .
> I have a VBA routine that sends through SMTP an email with a small
> Excel attachment with no macros. Everything works fine except the
> attachment is clobbered somewhere along the way. When the user tries
> to open the attachment, they receive an error message stating the file
> could not be accessed, it is read only or is stored on a server that is
> not responding. I've checked with our Network folks and it is not
> related to any type of virus scanning. I've tried different files,
> *.ZIP and *.DOC and all receive the same message. Detaching or saving
> the document does no good. All of our SMTP mail is handled by a Notes
> server.
>
> Any thoughts?
>