+ Reply to Thread
Results 1 to 5 of 5

click on mail address, print specific page to pdf, attach it to mail

  1. 07-08-2013, 08:46 AM #1
    Crosplit
    Crosplit is offline
    Registered User
    Join Date
    06-17-2011
    Location
    Split, Croatia
    MS-Off Ver
    2007
    Posts
    7

    Question click on mail address, print specific page to pdf, attach it to mail

    Good day,

    I would appreciate some help on this issue.

    I need to create some script that would help me printout a pdf file and attach it to the mail.

    Page breaks and page layout is arranged so that each row in the table supplies information for one page.
    Mail address is in the same row as is the number of the page I want to print out.
    Attached is simplified version of the table for example.
    example.xlsx

    I have never worked with VBA before, but I believe this is something that can be handled only with it, and I am willing to start learning...

    Thank you for your time
    Reply With QuoteRegister To Reply
  2. 07-09-2013, 04:01 AM #2
    Crosplit
    Crosplit is offline
    Registered User
    Join Date
    06-17-2011
    Location
    Split, Croatia
    MS-Off Ver
    2007
    Posts
    7

    Re: click on mail address, print specific page to pdf, attach it to mail

    Hi,


    Not sure if it is allowed to "bump" posts here, but I don't want it to sink down unnoticed
    Reply With QuoteRegister To Reply
  3. 07-09-2013, 04:02 AM #3
    humdingaling
    humdingaling is offline
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: click on mail address, print specific page to pdf, attach it to mail

    just did an VBA outlook mail macro

    Find it here
    http://www.excelforum.com/excel-prog...rget-date.html

    also did something for PDF recently

    http://www.excelforum.com/excel-prog...33#post3306433

    not sure if about the click on mail address to trigger the event
    cant think of way to do it without being buggy
    Last edited by humdingaling; 07-09-2013 at 04:16 AM.
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
    Reply With QuoteRegister To Reply
  4. 07-09-2013, 04:42 AM #4
    humdingaling
    humdingaling is offline
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: click on mail address, print specific page to pdf, attach it to mail 

    Please Login or Register  to view this content.
    here is code for printarea based on inputbox of what page you want to print
    PDF comes out, no preview,
    name of pdf is name of excel file if you want that changed you need to input some sort of saveas workbook function (i think)
    Reply With QuoteRegister To Reply
  5. 07-09-2013, 04:54 AM #5
    humdingaling
    humdingaling is offline
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: click on mail address, print specific page to pdf, attach it to mail 

    Please Login or Register  to view this content.
    got it all the way up to adding attachment to work...dont know the syntax never done that part before
    will look at that later
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1