Creating an e-mail with an e-mail attachment

Hi,

I have used a macro that is able to send e-mails with data from an excel.

Please Login or Register  to view this content.

Instead of sending this e-Mail I want to attach this mail to another mail.
Do you know, how to do this?

Best
pete

I think you just create another mail item and use the attachments.add method again? for example:

Please Login or Register  to view this content.

I still do not have it.

Do you mean like

Please Login or Register  to view this content.

Cheers
Pete

That is exactly what I needed.

I have one additional question. How can I save the e-mails as a .msg file? I tried

Please Login or Register  to view this content.

Directly after the . Display, but that did not work out. Do you know, how to do that?

Cheers
Pete

try

Please Login or Register  to view this content.

?

I have tried that directly after the .Display line but got an error.

Do I need to put this somewhere else or is there something I can do about that?

No idea, it was just a guess. Daft question but are you actually using "Path\filename.msg" or are you changing Path for the actual path name?
What is the error, thinking about it, if you are using olMSG and doing this from excel without a reference to outlook you need the constant as a number not olMSG. So you could try
.SaveAs "path\filename.msg", 3

Hi,

I have tried

Please Login or Register  to view this content.

but sitll got the same problem. Is spaces in the path a problem?

Cheers
Hauke

Spaces in the path shouldn't be a problem. Out of interest what was the problem with this code:

Please Login or Register  to view this content.