Search:

Type: Posts; User: stevewood1; Keyword(s):

Search: Search took 0.00 seconds.

  1. Replies
    10
    Views
    142

    Re: VBA code to remove attachments

    Panic over. It turns out I just can't spell 'Variant'. I've corrected that and it now seems to be working fine.

    Thanks for al you help.
  2. Replies
    10
    Views
    142

    Re: VBA code to remove attachments

    Hello,

    Thank you for your help. You're probably right. I don't think I need to re-protect the sheet as users open a new copy each time.

    When I try and run your code I'm still getting the error...
  3. Replies
    10
    Views
    142

    Re: VBA code to remove attachments

    I presumed from your answer that I would need to change the line to In OutLookMail but that gave me an error 'User defined type not defined.' I have attached the code below. I want the Macro to email...
  4. Replies
    10
    Views
    142

    Re: VBA code to remove attachments

    Hi, thanks for your response. When you say modify OutMail to the email object. The issue I have is that the file name is always different a mix of letters and numbers and when you click on the...
  5. Replies
    10
    Views
    142

    VBA code to remove attachments

    Hello,

    Can anyone help me with some VBA code that will remove attachments from a generated email? When I've looked online I've found examples that run in Outlook through an inbox but I have a...
  6. Strange attachment on automated email

    Hello,

    I have a macro that automatically sends an email with a copy of the workbook as an attachment. I recently made a slight change to add an extra cell value on to the name of the attachment...
  7. Replies
    7
    Views
    318

    Re: Concatenate formula

    That's great thanks
  8. Replies
    7
    Views
    318

    Re: Concatenate formula

    I can do little bits in VBA but wouldn't know how to do this.
  9. Replies
    7
    Views
    318

    Re: Concatenate formula

    Sadly not
  10. Replies
    7
    Views
    318

    Concatenate formula

    Hello,

    I have a list of information in a column that I want to concatenate into a single cell. I need a line break between each line of information but the problem that I have is that as I don't...
  11. Replies
    1
    Views
    141

    SendMail Macro in Excel 2016

    Hello,
    I wonder if anyone can help me with a Macro issue.
    We have an Excel form with a Macro that automatically emails the workbook. The line of code that does this is

    ThisWorkbook.SendMail...
  12. Re: Macro for copying cell from column B if column A is not blank

    Thank you for the really quick response.

    I have another sheet where I have to do the same thing but the dates are in row E10 and down and the value to copy is F10. I thought I would just be able...
  13. Re: Macro for copying cell from column B if column A is not blank

    That's great. Thanks for your help!
  14. Macro for copying cell from column B if column A is not blank

    Hello,

    I wonder if you can help.

    I have a worksheet with a list of dates is column A and an amount in Cell B2.

    I need a Macro that will copy the value of B2 and paste it into every cell in...
  15. Re: Copying data from one workbook to another

    Hi Fluff,

    That's working great. Thanks.
  16. Copying data from one workbook to another

    Hello,

    Please could anyone help with the following query.

    I have two separate workbooks that contain lists of case numbers in column B some of these numbers will be found in both workbooks and...
Results 1 to 16 of 16