HI
I’m trying to use Automator to create a new Mail message with the body of the email being the content of the cells that i have selected in Microsoft Excel.
I want to be using Excel, select a few rows of my spreadsheet and then right-click and select a service that will take what i’ve selected and create a new mail message with it in the body.
I created a workflow in Automator and saved it as a service. i can use the service (from the file menu only) in Firefox, Textedit, even NeoOffice but the service does not show up in Excel. I could just use NeoOffice but it is not as good as Excel for what I do.
How can i make the service work in Excel?
currently, the service is saved in Users/“MyUsername”/Library/Services/
it’s setup like this
“Service receives selected text from any app”
“get selected content from excel workbooks” (action from microsoft)
“copy to clipboard”
“get contents from clipboard”
“new mail message”
that’s it.
ideally it would be cool to not have to use the clipboard. then i could keep the clipboard free for other things. in other words i could copy something and when i run this action the clipboard would still have the contents that i had copied before. but more importantly, i would like to be able to run this service from within Excel and even better would be if i could run it from the contextual menu (right click). i haven’t figured that one out yet. I’m such a n00b, I know!
any help would be appreciated.
thanks
Steve