+ Reply to Thread
Results 1 to 2 of 2

modifying an email code to do additional job

  1. #1
    Forum Contributor
    Join Date
    03-30-2015
    Location
    Northampton
    MS-Off Ver
    2010
    Posts
    275

    modifying an email code to do additional job

    Hi Everyone

    i have this code 1 inside Code 2,

    Code 2
    Code:

    Please Login or Register  to view this content.
    Code 1
    Code:

    Please Login or Register  to view this content.
    when i use code 2 it save the file as required by combining two cells "our0112". but what happens is when i add code 1 it simply opens outlook and adds the original file, and not the saved pdf. could someone please help with this.

    also id like the the email to be sent to an email address that i have to the client that is select on the invoice (vlookup, i think). so if i select KN Group then the email that i have for that client would be used. eg [email protected] and if i change the client on the invoice to GE Lighting then then email for that client would be used.

    im sorry if it all sounds complicated.

    ive attached my file as i thought that would help

    thank you in advance
    Paul
    Attached Files Attached Files
    Last edited by Learning ExL; 05-20-2016 at 02:37 AM.

  2. #2
    Forum Contributor
    Join Date
    03-30-2015
    Location
    Northampton
    MS-Off Ver
    2010
    Posts
    275

    Re: modifying an email code to do additional job

    i really dont know much about outlook properties with regards to doing the code im really sorry

+ 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] Modfication of Existing Code for additional additional cells
    By thilag in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-29-2016, 03:00 AM
  2. Help modifying code of pasting range into email
    By miguelosaurio in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-11-2014, 09:10 AM
  3. Modifying an index/match forumla to include additional cells
    By trishcollins in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-13-2014, 09:49 AM
  4. Modifying an email macro
    By Switters023RS in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-19-2012, 06:10 PM
  5. Modifying VB Code/Macro to put selection into body of email instead of attachment.
    By excelstacy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-04-2011, 05:34 PM
  6. Modifying VBA to include one additional worksheet?
    By jonvanwyk in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-22-2010, 11:01 AM
  7. Help modifying code to check for text in a range prior to email sheet.
    By dcgrove in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-09-2009, 06:16 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