Results 1 to 2 of 2

Thread: Macro help for Excel to automatically fill in certain cell info into outlook email.

  1. #1

    Macro help for Excel to automatically fill in certain cell info into outlook email.



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I was wondering if anyone can help me with a similar issue. I tried using the code above as a template and modified some stuff but was unable to get it working.

    What the macro needs to do is. When it's run, I would like it to automatically fill in the person's name; client name and submission date in an email in Outlook


    Subj: Commission Request

    Body:
    “Thank you :Submitter Name: for submitting your commission request for :Client Name: It has been received by Julie Goldberg on :Submission Date: and is awaiting approval.

    Regards,”

    File is attached. CommissionTemplate.xlsx

    Thank you
    -bryan

  2. #2

    Quote Originally Posted by bryan View Post
    I was wondering if anyone can help me with a similar issue. I tried using the code above as a template and modified some stuff but was unable to get it working.

    What the macro needs to do is. When it's run, I would like it to automatically fill in the person's name; client name and submission date in an email in Outlook


    Subj: Commission Request

    Body:
    “Thank you :Submitter Name: for submitting your commission request for :Client Name: It has been received by Julie Goldberg on :Submission Date: and is awaiting approval.

    Regards,”

    File is attached. CommissionTemplate.xlsx

    Thank you
    -bryan
    please help

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •