Results 1 to 2 of 2

Thread: Creating code to publish pdf and attach via xl2010 and insert object in body of same

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    Creating code to publish pdf and attach via xl2010 and insert object in body of same

    I'm trying to create a code that will create a PDF from a specified range, attach the newly created PDF in outlook, then copy a second specified range within the same workbook and paste the image into the email body as an object

    (Ideally the PDF's filename would reference a specified cell and be archived in a specified location but I'm not too concerned about that.)
    I've got to a stage where I can get either the PDF to attach itself and send, or the object inserted into the body and send but cannot combine the two.

    I've attached the file, alone with the code.

    Any help/ideas would be greatly appreciated

    Thanks,

    Chris Brennan
    Attached Files Attached Files

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •