Search:

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

Search: Search took 0.00 seconds.

  1. Re: VBA to Copy specified worksheets into a new workbook and attach to email

    I have amended the code as above however it is still returning the same error message.

    when I go into Debug mode it is highlighting .Attachments.Add PdfFile

    Do you have any further...
  2. Re: VBA to Copy specified worksheets into a new workbook and attach to email

    Do I need to adjust anything else? It is coming back with the following error message

    Run-time error '-2147024894(80070002)':

    Cannot find this file. Verify the path and file name are correct.
    ...
  3. VBA to Copy specified worksheets into a new workbook and attach to email

    Hello,

    I have the attached code which pretty much does what I want but I require assistance in changing it so that it no longer produces a PDF but instead attaches the specified worksheets as .xls...
  4. Re: VBA code to convert excel to pdf and email it as attachment

    Hi everyone.

    I'm happy with everything that the attached code does however is it possible to amend the email signature so that it retains the formatting? It is currently coming through as plain...
  5. Re: VBA code to convert excel to pdf and email it as attachment

    Thank you for your help!

    The code works perfectly

    Regards

    Will
  6. Re: VBA code to convert excel to pdf and email it as attachment

    Thanks for all of the great codes they've been all really helpful so far.

    Is it possible to edit the attached code so that I can extract multiple sheets to PDF and attach them to the one email?
    ...
Results 1 to 6 of 6