emailing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm new to this group (my first posting) so apologize if this has been
covered elsewhere - I had a reasonable look and don't think it has been,
quite.

I use an Excel sheet to keep a track of orders for a not for profit theatre
play publisher. I've developed simple macros (using my equally simple
abilities) to generate invoices and reports, but what I'd really like to be
able to do is click on my "invoice number" cell and apply a macro that would
copy certain (relative) cells into an email body, append a title such as
"Print Order - Invoice Number " plus the number in that cell, then send it to
two email addresses, these addresses being the same every time.

Any ideas?

Regards
 
Ron

I'm going to show my lack of expertise here but....I downloaded your
file that allows one to just email one sheet from an Excel workbook.
My question is: How do I get that file incorporated into Excel?

Thanks
Walter Mayes
 
Hi Walter

You must copy the macro in a module in your workbook

First we open the VBA editor with Alt-F11
Then we use Insert>Module
Copy/Paste the macro in this module (change the address in the macro to yours(for testing))
Now we use Alt-Q to go back to Excel

Then In Excel we use Alt-F8 to get the list with macro's
Select the macro and press Run

See also this page for a Add-in (very easy to use)
http://www.rondebruin.nl/mail/add-in.htm
 
Thanks Ron. Will give it a shot.

Walter Mayes
Hi Walter

You must copy the macro in a module in your workbook

First we open the VBA editor with Alt-F11
Then we use Insert>Module
Copy/Paste the macro in this module (change the address in the macro to
yours(for testing))
Now we use Alt-Q to go back to Excel

Then In Excel we use Alt-F8 to get the list with macro's
Select the macro and press Run

See also this page for a Add-in (very easy to use)
http://www.rondebruin.nl/mail/add-in.htm
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Outlook Looking for macro to save multiple emails as .msg to folder and extracting the invoice ref. from the email body as the filename 4
Counting results of a formula 9
Average Unique 7
Outlook Creating an Outlook form 2
sort when using VLOOKUP 1
Adding values for all rows in a range 6
Copy a range instead of just one row but with condition 8
Dynamic Table Problem 5

Back
Top