+ Reply to Thread
Results 1 to 3 of 3

How to convert Word document to PDF and attach to an email ...

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

    How to convert Word document to PDF and attach to an email ...

    Dear all
    My excel sheet has list of invoices in Word format with their server addresses on Column D which is coming from SQL server. This is the location of the one invoice
    "\\svr-storage3\Accounts_Data\Docs\H\H\A\HHA6\62\Bill ref 223615_458254_1.doc"

    I have a macro that sends automatic email to my clients if their invoices unpaid over 35 days.

    Is there a way that I can pull the invoice from the server with the above location address and converi it to PDF then attache to the email?

    Here is my auto email code

    Please Login or Register  to view this content.

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

    Re: How to convert Word document to PDF and attach to an email ...

    can anyone help please?

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

    Re: How to convert Word document to PDF and attach to an email ...

    This is a new code which attach the invoice to the email in WORD format with this line
    Please Login or Register  to view this content.
    Is there a way to convert it to PDF before attaching to an email?


    here is full code

    Please Login or Register  to view this content.
    Regards

+ 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. Convert to PDF, Save to Network Drive, AND/OR attach PDF to an email (Automatically)
    By jonvanwyk in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-20-2011, 12:42 PM
  2. convert pdf into a word document?
    By sophie6 in forum Word Formatting & General
    Replies: 9
    Last Post: 04-02-2010, 06:13 AM
  3. Replies: 1
    Last Post: 01-06-2006, 06:35 PM
  4. How do I convert a word document into a Excel document
    By gwiltz2 in forum Excel General
    Replies: 1
    Last Post: 10-22-2005, 03:05 PM
  5. Replies: 4
    Last Post: 04-07-2005, 05:06 PM

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