e-mail

I have created a worksheet containing a PivotTable report that I need to be able to send via e-mail. I wrote some VBA code inside the worksheet titled "Rpt_Practice_Admin". It was taken from this website: http://msdn.microsoft.com/en-us/library/bb268022.aspx Scroll down to the section...

Hi All, I would appreciate any assistance you experts could give me. Thank you in advance. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p> I use the below code to e-mail the active sheet in my workbook and it works well. <o:p> </o:p> However my workbook...

Hi everybody, I've got quite a challenge. Every month I receive a huge file from the mobile phone company with the call details of every employee. Something like: Phone number / Number dialed / Call date / Duration / Cost I have to send every employee the details of his/her calls. I'd...

Hi I'm tying to send a Excel generated mail with attachment from Outlook, but get this security message: A program is trying to automatically send e-mail on your behalf. Do you want to allow this? If this is unexpected, it may be a virus and you should choose "No". Excerpts from the code I'm...

Is this possible within Excel, i.e. once data has been entered by Person A can an E-mail be automatically be generated to Person B to say that information has been updated and a response is required etc. Thank you. Graham

Is this possible within Excel, i.e. once data has been entered by Person A can an E-mail be automatically be generated to Person B to say that information has been updated and a response is required etc. Thank you. Graham

Hello,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I am hoping someone can help me with some simple code to automate what is a time consuming manual process. <o:p></o:p> <o:p></o:p> I am using Excel 2007 and have a file with over 100...

Dear all: I have written a function and entered it in a cell, which will check, say, the time in cell A1 (entered using Now() function) is greater than 17:00:00. If yes, the function will send out an e-mail to me. But, my problem here is, the Excel sheet needs to be recalculated / refreshed...

Title almost says it all. I can't write VB but I can copy and paste it where I need to stick it so I have copied http://www.rondebruin.nl/mail/folder3/mail4.htm - M"ail Range or Selection in the body of the mail" into a workbook and have been using it fine. The problem is that the e-mail is...

I found the following code on a previous thread. I was wondering how to change it so that it only sends an e-mail of the current worksheet, rather than an e-mail to all worksheets that have an e-mail address. Is there an easier code? Thanks in advance for anyones help. :biggrin: Sub...

I am going to have a list of about 500-1000 contacts in an column. Example: E4-E1004. I am wondering if there is a way to put a button or a macro that would e-mail all contacts.

Hi all, I have managed to create a UserForm using the great guide on Contextures. I now want to add an e-mail address to the form and then on a click of a command button and e-mail the contents of that entry to the recipient. I'm fine with the butons etc but have no idea about the VB for...

I am trying to send an automatic e-mail to Outlook notification when a date in a specific range of cells expires or comes close to an expiration date. Does anyone know of a function/formula/add-in/program that will accomplish this task?<?xml:namespace prefix = o ns =...

Good afternoon. My company runs a report that lists deals employees are working on. The information is grouped per employee with a page break after each person. Currently, the report is printed and each employee's information is scanned to PDF and e-mailed to the appropriate employee. We'd...

Hi guys, I have a worksheet which users fill in. I want to put a command button on it which when clicked will e-mail the file as an attachment but not send it and not specify any specific e-mail address. So I click the button it opens an e-mail in outlook with the file attached ready for me...