+ Reply to Thread
Results 1 to 6 of 6

Combine PDF Documents into one document and attach to an email

  1. #1
    Forum Contributor
    Join Date
    08-29-2006
    Location
    London
    MS-Off Ver
    Excel 2016
    Posts
    314

    Combine PDF Documents into one document and attach to an email

    Dear all

    Attached form has a User form that opens automatically when you open it, on the big list (ListView1) you can multi select the lines by holding CTRL key down + clicking mouse right button, It will highlight the selected lines then when you click the "Select Invoices" button it will list the selected invoices on the small window (ListView2) at the top. From here when you click the "Multiple Attach" button it will find each selected invoices' directory path at the excel Sheet("Multi") Colum F then convert each of the founded invoices to PDF and one by one it will attach these PDF invoices to one email.

    What I am trying to achieve is merge all the PDF invoices into one document then attach that document to the email. Can this be done?

    Thanks in advance
    Attached Files Attached Files
    Last edited by lapot; 05-10-2016 at 10:05 AM.

  2. #2
    Forum Contributor
    Join Date
    08-29-2006
    Location
    London
    MS-Off Ver
    Excel 2016
    Posts
    314

    Re: Combine PDF Documents into one document and attach to an email

    Can any one help or put me in right direction please?

  3. #3
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606

    Re: Combine PDF Documents into one document and attach to an email

    Cross post http://www.ozgrid.com/forum/showthread.php?t=199748

  4. #4
    Forum Contributor
    Join Date
    08-29-2006
    Location
    London
    MS-Off Ver
    Excel 2016
    Posts
    314

    Re: Combine PDF Documents into one document and attach to an email

    the link is mine, I put the same question another forum but it wasn't solved

  5. #5
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: Combine PDF Documents into one document and attach to an email

    I think you need to understand what a Cross Post is. Read this: http://www.excelguru.ca/content.php?184

  6. #6
    Forum Contributor
    Join Date
    08-29-2006
    Location
    London
    MS-Off Ver
    Excel 2016
    Posts
    314

    Re: Combine PDF Documents into one document and attach to an email

    sorry about this I didn't realise it might waste someone's time. I am still looking for answer if any one could help. I have stopped the other posting on Ozgrid

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to Attach Documents in Private Messages
    By Zach Boyer in forum Excel General
    Replies: 1
    Last Post: 03-15-2016, 11:50 AM
  2. Attach Documents/ Embedded Objects
    By khareem01 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-19-2014, 03:35 AM
  3. How to convert Word document to PDF and attach to an email ...
    By lapot in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-01-2014, 05:06 PM
  4. attach different worksheet and email them tdifferent email address through macro/vba/addin
    By arunverma004 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-03-2014, 08:20 AM
  5. [SOLVED] Email Macro to attach a non active worksheet to outlook email
    By mickgibbons1 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-21-2013, 08:38 PM
  6. SaveAs PDF and attach to email macro won't attach?!
    By Rerock in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-25-2012, 05:28 PM
  7. [SOLVED] email excel document with hyperlinks to mutliple documents
    By angiey in forum Excel General
    Replies: 3
    Last Post: 08-03-2006, 10:40 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1