?
Solved

Excel 2010 "Save and Send" only sends when Outlook is opened. Is this normal?

Posted on 2011-02-18
2
Medium Priority
?
1,680 Views
Last Modified: 2012-06-27
One of our users is using Office 2010. I am not completely familiar with all the in's and out's of the new edition and could use some insight.

When she uses the "save and send" feature in Excel, it opens up a new Outlook email with the attachment. She clicks send, but the mail is not sent until Outlook is opened. She does not use Outlook on a regular basis, preferring AOL's web interface instead.

Is there a way to make it send automatically, or is this "the way it is".

Thank you in advance.
0
Comment
Question by:akus1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 4

Accepted Solution

by:
SmittyPro earned 1000 total points
ID: 34928097
See Ron DeBruin's VBA methods, which will send regardless of whether or not Outlook is open:

http://msdn.microsoft.com/en-us/library/ff458119(office.11).aspx

HTH,
0
 
LVL 45

Expert Comment

by:patrickab
ID: 34934564
akus1,

This is Ron de Bruin's definitive web link for Excel emails:

http://www.rondebruin.nl/sendmail.htmhttp://www.rondebruin.nl/sendmail.htm

Patrick
0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a serious pitfall that can happen when deleting shapes using VBA.
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question