+ Reply to Thread
Results 1 to 2 of 2

Batch Doc to Pdf and email.

  1. #1
    Registered User
    Join Date
    Hobart, Australia
    MS-Off Ver
    Excel 2010

    Batch Doc to Pdf and email.

    Hi Everyone,

    I have the task of converting 10,000 or so .doc files to .pdf and then emailing the .pdf file seperatly. It will be processed in 50-100 file lots and preferably be run before leaving at the end of the day. So im trying to look at a solution that requires no input the macro is run.

    All files follow the same format of JobNumber.doc

    And the email is required to follow the following format. 1 email per File.

    To: test@test.com
    Subject: JobNumber <-(ie file name less extension)
    Body: Blank

    I'm using the macro below to handle the doc to pdf conversion. I'd appreciate some assistance or advice on how to handle the email side of the project.

    Althought not ideal i thought an option would be to import the file path of the converted folder contents to an excel document and then generate an email on a row by row basis.

    Please Login or Register  to view this content.
    Thanks for anybody who can help or point me in the right direction.

  2. #2
    Forum Guru macropod's Avatar
    Join Date
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010

    Re: Batch Doc to Pdf and email.

    You could probably adapt the email mailmerge attachments code from here: http://word.mvps.org/FAQs/MailMerge/...ttachments.htm
    Paul Edstein
    [Fmr MS MVP - Word]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1