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!)
Microsoft IIS Web Server

Avatar of undefined
Last Comment
Dan McFadden

8/22/2022 - Mon
INHOUSERES

ASKER
(sorry for the bad language - I forgot I put that in the body of the email!)
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
INHOUSERES

ASKER
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.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
Dan McFadden

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?
INHOUSERES

ASKER
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 McFadden

What scripting language are you using?
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
INHOUSERES

ASKER
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
Dan McFadden

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
INHOUSERES

ASKER
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 McFadden

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
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck