+ Reply to Thread
Results 1 to 6 of 6

Macro to send a pdf attachment via outlook from excel

  1. #1
    Forum Contributor
    Join Date
    01-06-2004
    Posts
    119

    Macro to send a pdf attachment via outlook from excel

    I've done a search on this which has resulted in a lot of complex code. I have a very simple code I use to create a PDF of a page and then switch back to my normal printer which is as follows:

    Please Login or Register  to view this content.
    All I need is an equally simple code (if possible) to add that will attach the PDF that is created from the code above to an outlook e-mail and automatically send it (same person every time, same subject line and body copy every time).

    What's the simplest way to do this?
    Last edited by Josiah; 08-26-2013 at 05:18 PM.

  2. #2
    Forum Contributor
    Join Date
    01-06-2004
    Posts
    119

    Re: Macro to send a pdf attachment via outlook from excel

    ...Anyone?

  3. #3
    Forum Contributor
    Join Date
    11-11-2012
    Location
    Muscat, Oman
    MS-Off Ver
    Office 365
    Posts
    521

    Re: Macro to send a pdf attachment via outlook from excel

    Hello Josiah,
    As i am a VBA learner cant help you with a code. In almost similar situation i found the link below very helpful.
    HTML Code: 
    http://www.rondebruin.nl/win/s1/outlook/mail.htm
    Hope this helps you too.
    Best Regards/VKS

  4. #4
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Macro to send a pdf attachment via outlook from excel

    I think this was taken from the internet someplace. Its the code behind out help tickets at work.

    Please Login or Register  to view this content.
    Thanks,
    Solus


    Please remember the following:

    1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    Highlight the code in your post and press the # button in the toolbar.
    2. Show appreciation to those who have helped you by clicking below their posts.
    3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

    "Slow is smooth, smooth is fast."

  5. #5
    Forum Contributor
    Join Date
    03-14-2012
    Location
    location
    MS-Off Ver
    Excel 2007
    Posts
    170

    Re: Macro to send a pdf attachment via outlook from excel

    or
    Please Login or Register  to view this content.
    blue

  6. #6
    Forum Contributor
    Join Date
    01-06-2004
    Posts
    119

    Re: Macro to send a pdf attachment via outlook from excel

    Quote Originally Posted by VKS View Post
    Hello Josiah,
    As i am a VBA learner cant help you with a code. In almost similar situation i found the link below very helpful.
    HTML Code: 
    http://www.rondebruin.nl/win/s1/outlook/mail.htm
    Hope this helps you too.
    Best Regards/VKS

    Thanks for everyone's help but this is EXACTLY what I needed. Perfect!! Thanks VKS!

+ 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. [SOLVED] VBA Macro to print to Pdf format and place as attachment in Outlook (Excel & Outlook 2007)
    By Webman1012 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-29-2013, 01:25 PM
  2. Excel to send email via Outlook (attachment)
    By uncleslinky in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-01-2012, 07:01 AM
  3. Send worksheet as an attachment to specified recipients via outlook
    By SunOffice in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 06-19-2011, 05:38 PM
  4. Send sheet as Outlook attachment
    By Jessy01 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-04-2011, 01:28 PM
  5. Send Excel attachment, but wait till Outlook closes
    By thepython in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-17-2006, 05:30 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