Mailto Command

  • Thread starter Thread starter Jim Evers
  • Start date Start date
J

Jim Evers

I created a macro for my night manager to send our end of day report
to all the related parties that need to see it. The macro saves the
document, clicks on a cell with a mailto command in it, and closes the
document. AOL pops up, he attaches the file and hits send, all the
recipients are already there.

There are nine receipients of the file and I need to add a 10th
person, but when I go to the Hyperlink to add her name it will not
allow me. I'm thinking that there is a character limit on the length,
probably 255.

Can anyone help me figure out a way around this? Let me know if more
info is needed to help solve this.

Thanks,

Jim Evers
(e-mail address removed)
 
You might consider setting up some kind of distribution list (is that possible
with AOL????).

Then when your night manager wants to add/delete email addresses, he can just
change the distribution list.

Or....

Add the name as a cc recipient.

or....

Ron de Bruin has loads of tips/examples for emailing from excel at:
http://www.rondebruin.nl/
 
Back
Top