PDA

View Full Version : Solved: Send email from excel



Desiree50
02-03-2010, 09:01 AM
I need assistance with an email error when in excel running a mail macro. I have two mail macro one is for workbooks and one is for individual work sheets in a workbook. In the individual worksheets the macro runs and pops up an error you have to say allow to send the email. The email address is on the first line of each worksheet. Our IT department is trying to figure out the security with outlook 2007 to get the error to disappear but have not been successful. I have downloaded the excel sendmail file for excel 2007 and went through all the secuity steps to no avail. I read where this problem can be resolved in the code itself. I am attaching the error I receive each time it sends the email. I am also attaching a copy of the code for the individual worksheets and the one for the workbooks. Can anyone help me with writing the code to get rid of the error?

Bob Phillips
02-03-2010, 09:50 AM
Take a look at Redemption (http://download.cnet.com/E-mail-Redemption-for-Outlook/3000-2382_4-10403728.html)

Desiree50
02-03-2010, 02:28 PM
This appears to be a dowload file for outlook is this correct? I will have to run this through several channels to see if I can get permission for a download. Can you tell me more about this redemption download?

Bob Phillips
02-03-2010, 03:05 PM
It suppresses the warning message.That is about it.

Bob Phillips
02-03-2010, 03:08 PM
Here is some more info on the Redemption (http://www.dimastr.com/redemption/)site

and Ron de Bruin has more info on his site (http://www.rondebruin.nl/mail/prevent.htm)

Desiree50
02-03-2010, 03:10 PM
Alright Thank you I will start the process then to get permission to download this file.

Desiree50
02-04-2010, 09:06 AM
We tried installing the redemption file and the product did not install completly the first web site could not conect for the email and the second could not load the ddl file portion. IT tell me we willl have to purchase distributed version of the product since we could not get the other site to load right on our systems. They are questioning if we purchase the distributed verision for two computers if it will work then so it is a debated topic now. Is there now way of writing this into the VBA code itself to do this?

Bob Phillips
02-04-2010, 12:23 PM
You could use CDO as explained on Ron's site.

Desiree50
02-10-2010, 07:48 AM
Resolved issue using Ron's site and CDO. Thank you for your assistance.

lucas
02-10-2010, 08:13 AM
Desiree, please mark your thread solved using the thread tools at the top of the page.

To keep good people from reading an entire thread just to find it's been resolved.

Desiree50
02-10-2010, 08:15 AM
Sorry didn't know I needed to that. Will stay on top of it from now on.

lucas
02-10-2010, 08:17 AM
It's ok, it's just a courtesy to those offering help.