cdo

Hello All, I was wondering if it was possible to email a cell range to a specific email and then a different cell range to a different email? I already use CDO to email a pdf to an email list, but this is much different and I'm not really sure if it is doable. A few details: The emails...

Hello All, I have been using CDO to email pdf attachments to my employees, and for the most part it has been successful. I now am facing two different issues I am hoping to get some assistance with. The first is that a majority of the emails that I send are email to texts, where I have a...

Hello All, I have been using CDO to email pdf attachments to my employees, and for the most part it has been successful. I now am facing two different issues I am hoping to get some assistance with. The first is that a majority of the emails that I send are email to texts, where I have a...

Hello all, I am trying to be able to send mail using CDO, and am very much over my head for my current skill level. Any help would be greatly appreciated. Here is what I have so far, but I keep getting syntax errors. Sub emailtest()Dim CDO_Mail As Object Dim CDO_Config As Object Dim...

Please help me, have search the entire internet for a useful VBAcode Is it possible to make a code in vba to plant a picture inside the emailbody of a G-mail? Or just transfer a table to the emailbody? I’m using CDO messaging to send emails from Excel via G-mail. Best regards Mia

Hello All, I would like to than everyone in advance as the information I have gathered and things I have learnt from the Mr Excel forums make me look like a genius at work. I now have a problem with trying to attached a file to an email using vba and cdo. When I type the file location into the...

Hi everyone, Just trying to send an email (gmail) using VBA CDO in excel and my problem is in the title. I want my mail attachment to be selected in a specific cell (that is doing a Vlookup on a customer name) in one of my sheets: MAIL.AddAttachment (Sheets("MAIL").Range("N17").Text) Thanks...

Hi everyone! (first post here) I'm actually trying to send an email (using gmail) from Excel with VBA. Everything works just fine except two things. First: There is an image that I want to appear on the left top of the mail. (business logo). You'll see in the code that I'm using HTML.body...

Hi all, Is it possible by using the Ron De Bruin's code for sending emails using CDO to display the email before you send it? Any ideas are welcome. Alex

Hello Wizards: I'm running XP and office 2007. I've created a userform and now I need it to send an email with the information in the userform. I did it the simple way and my problem was that at the end, I went to my outlook and the email sent shows up in the sent items. I can´t have that and...

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...

I'm attempting to use CDO with Win7/Excel 10 and NO Outlook (Express or otherwise). Before this I tried code posted by Ron de Bruin which also triggered a "class not registered" error at the line: Set Flds = iConf.Fields This is the latest code I've tried (posted at Paul Sadowski.com) and the...

Does anyone know how to successfully send an attachment using CDO. Below is a script that I know works without the AddAttacment line included. As soon as I add the AddAttachemt line back into the code it will keep erroring out at the AddAttachment line. If I change the attachment path to a...

Is there any way in the world to send an attachment using CDO with the attachment as a variable instead of the full file path? My problem is that where I am using my save-and-mail script the users machines will not allow them to save a file on the C:\ drive but that is the only place I can...

Is there a way to pass the recipients email addresses through a variable instead of manually typing in the address when sending a message using CDO?

The code below seems to be what I am looking for to enable the users of my forms to send me a message without having a email client installed on their system. My domain provider requires smtp authentication so thats why I choose this crazy long script. When I try to run this code though get an...

Greetings! First, I just want to say I've never come here and not found an answer to any issue I was facing, either by posting (rarely) or by simply searching some keywords. This place is a goldmine! So, proper supplications having been performed, I now present this poser: I have a...