Solved

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

Posted on 2011-02-18
2
1,673 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
2 Comments
 
LVL 4

Accepted Solution

by:
SmittyPro earned 250 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

My experience with Windows 10 over a one year period and suggestions for smooth operation
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …

929 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now