sendemail

Please someone help, I have a code to create PDF file from range of cells add as email attachement and send. Right now I need to add an image in the end of email body, it worked before but now only red cross appears in the end. What is wrong and how can I fix it? Sub AttachActiveSheetPDFXX()...

I have this code to send PDF files but now I need to send word document instead of PDF, could someone help to adjust the code: Sub PDFXX() Dim SaveAsStr As String 'SaveAsStr = ActiveWorkbook.Path & "\" & ActiveSheet.Range("J1").Value SaveAsStr = ActiveSheet.Range("J1").Value...

Hello so I have the below right now and it's working great but now I want to add in that it also CC's another email when sending. CC email address will be entered in cell L4. If it's not possible to do a CC like this is there a way that I can just have it sent to the company@company.com and...

It's been awhile since I've done VBA so I'm rusty I have a sheet, that has an If statement saying =IF(B9>0,"Fields left to complete","OK to submit") there's also a Submit button. If user clicks submit button and cell says "OK to submit" then a msgbox comes up saying it will send an email to...

A B C D 1 Staff Team Manager Coaching Urgency 2 Jon Mark Sales Urgent 3 Sam Steve Billing Non Urgent 4 Jacob Mark Collecting urgent 5 Susan...

Hi <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I am using a macro to send several emails from outlook 2000.<o:p></o:p> <o:p></o:p> The problem is that whilst sending the emails most of the time the sendkeys work but other times the...