We help IT Professionals succeed at work.

Excel attachment smtp IIS7 (or any attachments)

INHOUSERES
INHOUSERES asked
on
358 Views
Last Modified: 2014-11-17
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!)
Comment
Watch Question

Author

Commented:
(sorry for the bad language - I forgot I put that in the body of the email!)
Dan McFaddenTechnical Lead - Active Directory
CERTIFIED EXPERT

Commented:
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

Author

Commented:
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.
Dan McFaddenTechnical Lead - Active Directory
CERTIFIED EXPERT

Commented:
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?

Author

Commented:
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

Dan McFaddenTechnical Lead - Active Directory
CERTIFIED EXPERT

Commented:
What scripting language are you using?

Author

Commented:
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.
Technical Lead - Active Directory
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
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.
Dan McFaddenTechnical Lead - Active Directory
CERTIFIED EXPERT

Commented:
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
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.