+ Reply to Thread
Results 1 to 13 of 13

PDF as attachment

  1. #1
    Forum Contributor nuttycongo123's Avatar
    Join Date
    01-26-2011
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    149

    Thumbs up PDF as attachment

    Dear All,
    I am trying to send a common e mail to many clients to creat awareness for the enviornment.I am getting as far as creating E mails but I am not able to attach the PDF file to the E mail which is placed on my desktop ..
    here is the code and the Excel work Book (Dummy ) an an example.
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by nuttycongo123; 05-28-2011 at 02:57 PM.
    N

  2. #2
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: PDF as attachment

    Hi N

    Here's a link to code I use when I wish to send a PDF from Excel with Outlook. What the code does essentially is, it creates a PDF file from what the code tells it to and then does the Email thing. I suspect this is NOT what your trying to do...however, the code CAN be modified to do WHAT I suspect you're trying to do.

    What I suspect is that you have a currently existing PDF file you wish to Email to certain people that are listed in your attached file. If my suspicions are correct, try to modify the code to do as you require...if you're stuck, attach a generic copy of your PDF and I'll show you how. I actively use code that does exactly this.
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  3. #3
    Forum Contributor nuttycongo123's Avatar
    Join Date
    01-26-2011
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    149

    Re: PDF as attachment

    Quote Originally Posted by jaslake View Post
    What I suspect is that you have a currently existing PDF file you wish to Email to certain people that are listed in your attached file. If my suspicions are correct, try to modify the code to do as you require...if you're stuck, attach a generic copy of your PDF and I'll show you how. I actively use code that does exactly this.
    you are correct J but the link is missing here in your reply can you resend it for me to work on ..
    rgds
    N

  4. #4
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: PDF as attachment

    Hi N

    Sorry 'bout that...thought I'd copied the link...here it is http://msdn.microsoft.com/en-us/libr...ffice.11).aspx

  5. #5
    Forum Contributor nuttycongo123's Avatar
    Join Date
    01-26-2011
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    149

    Re: PDF as attachment

    Dear J,
    Thanks for the effort .I have managed to get as far as generating e mail ,but without attachment ,all the codes I ref. to talk about creating workbooks,worksheets,csv,text files and then sending .pdf as an attachment ,I dont want to creat pdf ,just want to attachthe one that's there on the desktop to all the e mails i am sending.Here is the code for you ,the only problem is I am not able to get the pdf file as an attachement to these e mails .
    Please Login or Register  to view this content.

  6. #6
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: PDF as attachment

    Hi N

    The attached is a modification of the procedure I personally use to email PDF's for an organization I'm involved with. Try it and see what works and/or doesn't work for you.

    You'll need to change two lines of code in Module1
    This line of code needs to be set to the path where your PDF file lives
    Please Login or Register  to view this content.
    This line of code needs to be set to the path where your signature lives
    Please Login or Register  to view this content.
    let me know of issues.
    Attached Files Attached Files

  7. #7
    Forum Contributor nuttycongo123's Avatar
    Join Date
    01-26-2011
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    149

    Re: PDF as attachment

    Dear J
    Bulls Eye ..
    Regards
    Last edited by nuttycongo123; 05-13-2011 at 07:45 PM.

  8. #8
    Forum Contributor nuttycongo123's Avatar
    Join Date
    01-26-2011
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    149

    Re: PDF as attachment

    Dear J,
    I somehow managed to tweak your code to match my requirement but now I am stuck bigtime and need your help, problem is, I am not able to modify the Subject of the Email in a specific format.I am attaching the working for your valuable feedback.
    Regards
    Attached Files Attached Files
    Last edited by nuttycongo123; 05-28-2011 at 01:40 PM.

  9. #9
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: PDF as attachment

    Hi N
    Is this the same project as the subject of my Post #6? If it is, what happened to the procedure to update location? The code in the workbook attached to my Post #6 will require another approach to accommodate your most recent requirements.

  10. #10
    Forum Contributor nuttycongo123's Avatar
    Join Date
    01-26-2011
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    149

    Re: PDF as attachment

    Dear J,
    This is not much related to post# 6.I am tweaking your post # 6 reply for a new assignment which does not involve location, it has more to do with the reminders to external associates.Regards

  11. #11
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: PDF as attachment

    Hi N

    You can't introduce a new project into this Thread...Forum Rules and etiquette don't allow it. If this Tread is solved, please mark it as such.

    Then please start a new thread for your new issue.

  12. #12
    Forum Contributor nuttycongo123's Avatar
    Join Date
    01-26-2011
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    149

    User Form for outlook Email

    oooppppsss!!!! Thnks J for reminding me I have posted the new thread ..Regards
    Last edited by nuttycongo123; 05-28-2011 at 03:18 PM.

  13. #13
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: PDF as attachment

    Hi N
    I see you've marked your Thread as solved. Now, start a NEW Thread detailing your NEW requirements. Attach your file to the NEW Thread. PM me with the NEW Thread reference an I'll look at it.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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