Macro creating an Email

[Gambinus]

I am new to using Macros and am not sure how to go about this.

I have a workbook with 20 worksheets. I would like to create a Macro on each sheet that when you click a button it creates an email to a list of recipeients for each sheet.

HELP!

thanks,

[Leith Ross]

Hello Gambinus,

Do you have a sample sheet you can post, or explain how the information is arranged on the worksheets?

Sincerely,
Leith Ross

[Gambinus]

I would like to send each individual worksheet as an attachment to a list of recipients.


Example:

Worksheet A, B, C


Send worksheet A to Larry and Bob
Send worksheet B to Mary
Send worksheet C to Biff

So on each individual worksheet, I would like a button, so when I click on the button on Worksheet A and email opens with the Worksheet A as an attachment, with Larry and Bob in the sender/To field

[Leith Ross]

Hello Gambinus,

Sorry, I should have asked this in the last post. Are the recipients email addresses in column "A" or just their names? If you are using just the names are you sending the emails via Outlook? I am asking to determine whether the code needs to resolve the names using your address book.

Sincerely,
Leith Ross

[Gambinus]

Right now I dont have the names anywhere. Right now I just have the workbook and worksheets with the data. I can add the contact emails whereever.

This email would be going out via Outlook

[Leith Ross]

Hello Gambinus,

Sorry this took so long there has been a long going on that has prevented me finishing my code projects. This macro will need some tweaking to fit your needs, but the basics are all here.

Please Login or Register  to view this content.

Adding the Macro
1. Copy the macro above pressing the keys CTRL+C
2. Open your workbook
3. Press the keys ALT+F11 to open the Visual Basic Editor
4. Press the keys ALT+I to activate the Insert menu
5. Press M to insert a Standard Module
6. Paste the code by pressing the keys CTRL+V
7. Make any custom changes to the macro if needed at this time.
8. Save the Macro by pressing the keys CTRL+S
9. Press the keys ALT+Q to exit the Editor, and return to Excel.

To Run the Macro...
To run the macro from Excel, open the workbook, and press ALT+F8 to display the Run Macro Dialog. Double Click the macro's name to Run it.

Sincerely,
Leith Ross

[Gambinus]

Thank you Leith Ross, that worked great. Is it possible to change the Macro so that instead of automaticaly sending the email it just brings one up?

[Leith Ross]

Hello Gambinus,

To bring up the Outlook mail inspector is an easy change. You will need to edit the portion of the macro that sends the emaii. Here it is below with the change in red...

Please Login or Register  to view this content.

sincerely,
Leith Ross

[Gambinus]

Again, thank you, Leith Ross.

One more fine tuneing. How can I set up the email to include recipients to be CC'ed?

Thank you again.

[Leith Ross]

Hello Gambinus,

Where are the recipients names? Are these the individuals' email addresses or just their first and last names?

Sincerely,
Leith Ross

[Gambinus]

It will be there email addresses. Currently They are not located anywhere. I can put them wherever.

[Leith Ross]

Hello Gamibinus,

I have added the CC line to the email. This is a string value. Each email address is separated by a semicolon. The names can be hard coded if they aren't going to change frequently or loaded from a worksheet.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

[Khaos176]

I am trying to do something very similar only i am using Outlook Express and cannot seem to get it to work. I have replaced the ("Outlook.Application") with ("MSIMN.Application"). Any ideas what i could be doing wrong?

[ROP1]

Hey Lieth,

Do you have a minute to help with a simular request, sending emial from excel file.

cheers
Rop1

[Leith Ross]

Hello Khaos176 and ROP1,

Please start a new thread to ask your question. Asking questions in another post can become confusing very quickly. I will be happy to answer your questions once you start a new thread.

Sincerely,
Leith Ross