Emailing; Find identity of sender

Leith,

I'm sorry, my post wasn't clear enough.

The routine will be run by about a dozen people. Already it emails me and my boss. What I want is for the report to mail itself to the SENDER, whoever that sender is, rather than having them go to their "Sent Items" for a copy.

Since I don't know who will be sending, I can't hardcode their email address in.

Yes.

The userform boils a lot of information out of various spreadsheets and puts it into a small report which tells my users what problems they need to look into.

It sends a copy of that report as an attachment to an email to me and to my boss, so we know that 1) the user DID run the report, and 2) they ran it at THIS time. The user as well needs to keep a copy of the email in case there are ever any questions. While they could retrieve it from their sent mail, I would much prefer that they instead also get copied on the email.

Possble?

Leath,

Sorry I haven't replied, I was on Christmas vacation. I tried adding your code to my mail routine, and it didn't work for me. I've posted the full code below for your perusal, so hopefully you can point out where I've messed up. I THINK it may be this line:

Please Login or Register  to view this content.

because it seems to me there should be a period or something between Move and olInBox. Here's the full code:

Please Login or Register  to view this content.

Sorry, I guess I could have been clearer. What I meant was that there was no change. The email and worksheets are still being sent to the addressee, and I still have a copy in my sent items, but don't have a copy in my inbox. No error message, it just didn't copy it.

I don't know which is the default. Under "Documents and Settings" the following accounts are set up on my computer:

Administrator
All Users
Default User
Business_local
jomili
Mary
Ted
Alice

Mary, Ted and Alice used my computer before I got here, and our IT dept doesn't wipe everything clean for the next user. In Outlook, when I open it asks which profile to use, and my only options are Outlook or jomili. I choose the latter. I think for my users across Texas they've got a similar situation.

I guess I'll have to do that, or educate my users to retrieve a copy from their sent items. Thanks loads for trying. Should I mark this thread as "Solved", or leave it open in the hope that someone else might have an idea?

Hold it, I have some questions:

1) Shouldn't we Dim olSentItems and olInBox as something?
2) Where do the numbers on the DefaultFolders (5 and 6) come from? Could they be different on my machine?
3) I've put this macro in Excel; should it be an Outlook macro instead?

Leath,

I beg to differ with point A. Here's the first part of the code you originaly posted:

Please Login or Register  to view this content.

Should I Dim OlInBox and olEmail as Objects? Will that make any difference?

On B, I AM using Outlook 2003, so I guess the folder names should be right. I'm just trying to cover all the basics before I appeal to IT.

Thanks,
Jomili

Leath,

It (ALMOST) works! It's not copying the letter just sent, but instead it's copying the one before the one I just sent. Maybe a slowdown in the mail process (ie: it's not getting to my sent items before Excel pulls from my sent items)? Can we put a delay in?

Never mind. I looked online and found the answer. I changed my macro to add a timer line:

Please Login or Register  to view this content.

That adds a 3 second delay, which appears to work. I may see if I can shorten it, but for now a 3 second delay is liveable.

Thanks for all your help, and sorry I didn't figure it out sooner. I should have remembered that everyone else's equipment is much faster than mine.

I'm marking this one solved, and posting my finished (working) code below. If you can point out ways to make it more effecient please do so.

Please Login or Register  to view this content.