Solved

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

Posted on 2011-02-18
2
1,677 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 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

How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

Question has a verified solution.

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

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

726 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