sendemail

  1. M

    Make a word document from range of cell and send as attachment from outlook

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

    Can you have a VBA send an email with cell ref CC too?

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

    URGENT: VBA msgbox send email issue

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

    Send Email Using MACRO

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

    Check createobject completed before send email

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

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top