Create Emails and Save it to Folder

Good evening,

I have attached code to convert a workheet to pdf, create an outlook email and attach created pdf to created email. On created email subject is delivery reference which is a range.

Currently I am using it without any problem. But it creates only one email. What i am trying to do is creating seperate emails with delivery reference numbers. For example currently I have 5 different delivery numbers as a result i want to create 5 emails. Subject of these emails should be delivery numbers.

Second goal is to save these emails to folder. I could not figure out it so far. I tried .SaveAs ("folder path"), it did not return error, did not work either.

I would like to know if these objectives are possible if an excel master would like to help.

Thanks,

Hi davesexcel,

Thanks for your reply. Yes this is what I would like to. Range is fixed, however in some occasions a cell in between that range can be blank. In that case I dont want code to create an email for blank cell.

And as a second goal, I could not understand why .SaveAs does not work.

Thanks,

Hi davesexcel,

It works perfect thanks.

When I try to .SaveAs created emails as.msg, i dont see any error message, just does not save anything

Hi davesexcel,

I removed it because i was ashamed. Sorry for that. Below is what i have tried vey unsuccessfully

Please Login or Register  to view this content.

What happens is, instead of saving created emails, above code saves pdf file to desktop

hi,

still no luck. Could it be related to object ?

Good afternoon,

I changed and tried, still no luck. It still creates emails however none of them are saved

Originally Posted by rorya

You're missing a backslash on the end of the path here:

Please Login or Register  to view this content.

I added a backslash but nothing changed. still does not save emails

Originally Posted by bakerman2

My guess is that the error lies here.

Please Login or Register  to view this content.

You don't create a name for the file since m.Subject is empty.

Hi, i am sorry I did not understand what do you mean

Hello,

When i changed

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

, it creates only one email and returns object required error and highlights

Please Login or Register  to view this content.