sending vba e-mail

Hey, I am having difficulties with putting a VBA code together. The code should send personalized emails taking data from different excel cells. I also need a greeting line such as Hello! and beginning line such as "Here is the overview of the used service:" and after that VBA code should take...

i keep getting an error can some1 look at this and help me fix this code? or help me with the notes in this code Sub sendemail(what_address As String, subject_line As String, mail_body As String) Dim olapp As Outlook.Application Set olapp = CreateObject("outlook.application")...

I am having trouble with this macro. The file is a form the user completes (v1), then clicks the macro to submit (v2). In doing so, a new version is created. The user goes back to his form, and has a button he can clear the form and submit a new request. But now the form is actually named...

I've referenced Ron DeBruin's articles. I've tried CDO and it seems SMTP is blocked. I've tried sending via Outlook 2007, but can't get past the Outlook dialog asking if I want to allow Excel to send the mail. I've tried using SendKeys at various points. I've examined the gmail example found...

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p>Hello Excel chaps,</o:p> <o:p> </o:p> I have a form that will be opened through a portal as a read only.<o:p></o:p> <o:p> </o:p> As soon as all the fields are filled I want the user to press Send and then...

Hi all, I'm using Excel 2010, and the code below works but it's not optimal. I'm trying to create a vba code that attaches a chart into the body of an e-mail to be viewed by e-mail (outside of network) and iphone. Searching online, I found a way to export the chart into a...