Modify a Module with a Userform?

All depends on where John, Peter and New derive from.
Are you looking at a "mail merge" situation here?

Post a sample workbook, it will help greatly.

BSB

Here is the code.... It works fantastic as it is, I just want to automate the process by letting the user change the To:, CC:, Subject lines of the Module

Please Login or Register  to view this content.

Regards,

John

Change it at what point and in what manner?

Keep in mind we have no idea what your workbook does, other than the code above. We have no idea of data layout or purpose.

Do you want input boxes to add email addresses? Should they come from a predefined list? What's wrong with just dispaying the email without those field filled in and let the user to that at that point?

Too may questions....

BSB

Great suggestion... I will give that some consideration.....

Just thought there may be a way to overwrite that section in the module and then the user only needs to do the entry once... the module pulls the data from the specified ranges in the worksheet... easy peasy...

If anyone has a suggestion I will gladly appreciate it!!!

Regards,

John

Okay everyone,

I re wrote PG's code and now it works and processes the email just fine... However, the goals is to get the EmailTo, EmailCC, and EmailSubject to be changed in the module.

The code does function and produces an email and that is great, but the module "Public Sub Mail_Selection_Range_Outlook_Body" will do the email.

Any suggestions??

Best Regards,

John

Originally Posted by JJFletcher

Okay everyone,

I re wrote PG's code and now it works and processes the email just fine... However, the goals is to get the EmailTo, EmailCC, and EmailSubject to be changed in the module.

The code does function and produces an email and that is great, but the module "Public Sub Mail_Selection_Range_Outlook_Body" will do the email.

Any suggestions??

Best Regards,

John

I might be wrong, but I don't believe it is actually possible to edit a module or any bit of code through the use of the code itself. Doing so could allow people to manipulate the code to either exploit or break it.

I'm assuming this is because when you open the sheet it no longer remembers what "EmailTo, EmailCC, and EmailSubject" are set to?

My only solution to this is to create a "helper" sheet, one hidden away but stores variables for use. You would have to change the code to write these values to the cells you select, rather than assign them to the variables. Then in your email macro, change "EmailTo, EmailCC, and EmailSubject" to the cells you chose on the helper sheet.