Link to home
Start Free TrialLog in
Avatar of INHOUSERES
INHOUSERES

asked on

Excel attachment smtp IIS7 (or any attachments)

Hi Experts,

I think I'm a little over my head here, and I'm getting really frustrated as to why this is so complex?!

I'm writing files that go into a IIS7 pickup folder that get emailed. This works - I'm happy with that.
I'm now trying to attach excel files in each email, but that's seemingly difficult (why? - seriously WHY is this so difficult?!)

I've searched google and here and I can't find anything, I can only assume I'm searching for the wrong thing.
Let's face it - I thought this would be easier to find a solution because surely everyone would think this should be simple?!

Anyway, here's the code I have going into the pickup folder (some of it was found via google, so I'm not 100% sure what it does, but it was a start) - it attaches a file, but the file doesn't work. It also comes through as "Ctempttest.xls" instead of just "test.xls":

To:email@address.com
From:email@address.com
Reply-To:email@address.com
Subject:Testing Attachments
MIME-Version:1.0
Content-Type:multipart/mixed;
  Boundary="Attached"

--Attached
Content-Type:text/html;
<b>piss</b>&nbsp;<u>off</u>

--Attached
Content-Type: application/vnd.ms-excel; 
  name="Hello.xls"
Content-Disposition: attachment; 
  filename="C:\temp\test.xls"

Open in new window


Getting angry over this (as you can probably tell!)
Avatar of INHOUSERES
INHOUSERES

ASKER

(sorry for the bad language - I forgot I put that in the body of the email!)
Avatar of Dan McFadden
In the code, I would use a double back slash in the filepath.  It would look like this:

filename="C:\\temp\\test.xls"

Which is escaping the backslash.

Dan
Hi Dan,

Thanks for the comment.

Didn't make any difference unfortunately.
If I save the attachment that comes through, and open it in Notepad, it's completely blank. It's as if it's creating a new file and trying to name it as the location instead of taking the file I want it to.
Have you tried placing the attached file in the same directory as the .eml file?  then the filename key would look like:

filename="test.xls"

Are you using a script to do this?
A script generates a text file that goes into the pickup directory. Placing any files in the pickup folder gets set automatically - it will only process files in the right format.

I know that is all working because it sends an email.
The issue is definitely the code to attach a file. Most likely this part:
--Attached
Content-Type: application/vnd.ms-excel; 
  name="Hello.xls"
Content-Disposition: attachment; 
  filename="C:\temp\test.xls"

Open in new window

What scripting language are you using?
It's a project in VBA attached to an MSAccess database that is creating text files that go into that pickup folder.

I've no idea what language it is outputting. It's via SMTP.
ASKER CERTIFIED SOLUTION
Avatar of Dan McFadden
Dan McFadden
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I think I'm gunna have to rethink this then. It looks like this is just to complex as it is.

Thanks Dan for the contribution. I'll check out CDO.
If interested, I have, somewhere, vbscripts with CDONTS for a similar task.  It could be a starting point for you.

You could message if interested.

Dan