Excel Macro lotus notes email clear attached sheet

[johnny_w]

Good afternoon,

A quick question.
I've gotten almost everything to work.
Just a final step in the macro won't seem to do what I want.

Hope someone can help out...

To explain.
The macro below is a simple macro which when executed checks the excel file and sends out en email when needed.
With the Excel file as attachment and a string as subject and body of the email.

There is just one more thing I need the macro to do.

Which is clear the excel sheet when done.
I can’t seem to get another part of VBA code inserted into the email part.

Am I doing something wrong??

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[hulpeloos]

Jones , what you mean by clearing the excel file , as in updating/removing something in the excelfile itself ?
If thats the case , something outside the mailing procedure is what needs to be done.

[johnny_w]

Hi Hulpeloos...

That's exactly what I need...

The filled in Excel form needs to be cleared.
For people to be able to enter new data and re send the sheet.

I'm not quite sure how to do the suggested.

If that’s the case, something outside the mailing procedure is what needs to be done.

Can I make the macro run sub macro to clear the sheet?

I'm quite new at VBA I don't know how to link the 2 or make the sub macro run when the sending is done.

Could you help me a hand???

[hulpeloos]

Sure alway willing to help a hand.
In the code you have already for emailing we will add below in bold

Please Login or Register  to view this content.

Now go to your excel file and there you insert a new module , in that module you type below

Please Login or Register  to view this content.

[hulpeloos]

To make it easier to work between us you can upload the file , be sure to adjust information you do not want to share to some fictional info.

[johnny_w]

Good afternoon hulpeloos,

That worked!!!

But now a new problem arises...
My bad for not posting the complete Macro.


The macro runs on the Main macro (See the main_Macro below):

Which corresponds with one of 4 sub macro's

When entering the

Please Login or Register  to view this content.

in for example for sub macro EmailFile_MADI
It will clear the data before sub macro EmailFile_MADIV can run.

I think I need an If statement??

Please Login or Register  to view this content.

[hulpeloos]

you can wait to clear the file till the end , so the you place it before the end sub (see bold below)
now i see that you have an exit sub executed when MADIV is finished , you can remove this (underlined part) since MADIV is last in list anyway.

Please Login or Register  to view this content.

side note : the "Else's" you have in your main are not needed either.

[johnny_w]

HULPELOOS YOU'RE THE BEST!!!

It works just the way it's supposed to now!!!
I've been fighting with the code for 2 weeks now...
The solutions were this easy...

THANKS FOR YOUR HELP!!!!

[hulpeloos]

please feel free to mark this as solved.