+ Reply to Thread
Results 1 to 12 of 12

Excel Sheet Automatic Outlook Email

  1. #1
    Registered User
    Join Date
    10-27-2017
    Location
    New York City
    MS-Off Ver
    2016
    Posts
    39

    Excel Sheet Automatic Outlook Email

    Hi,

    I'm working on an excel template that automatically sends an email through outlook with information in the sheet. I'm very bad at VBA programming and used most of the script as a template. I am able to get the email to create automatically but I would like to include references to exact cell values in the body of the message rather than just manual text. Please let me know what I need to include from the script below to allow cell references within the email body. Thank you very much.

    Please Login or Register  to view this content.

  2. #2
    Valued Forum Contributor than_gold's Avatar
    Join Date
    10-17-2017
    Location
    Coimbatore India
    MS-Off Ver
    Office 365
    Posts
    646

    Re: Excel Sheet Automatic Outlook Email

    Check this link to use cell values in your body of the mail.
    https://www.rondebruin.nl/win/s1/outlook/bmail2.htm
    Regards,
    Thangavel D

    Appreciate the help? CLICK *

  3. #3
    Registered User
    Join Date
    10-27-2017
    Location
    New York City
    MS-Off Ver
    2016
    Posts
    39

    Re: Excel Sheet Automatic Outlook Email

    Thank you!

    Again, I'm pretty bad but to me this looks like it's going to include the information in the excel sheet along in the email? What I want, for example, in my sample body email it says "Please note that part number [RMA]", I would like it to be something like "Please note that part number [Cell X]"

    Thanks again.

  4. #4
    Valued Forum Contributor than_gold's Avatar
    Join Date
    10-17-2017
    Location
    Coimbatore India
    MS-Off Ver
    Office 365
    Posts
    646

    Re: Excel Sheet Automatic Outlook Email

    Please Login or Register  to view this content.
    -> just an example of L7, where your RMA in the excel.

  5. #5
    Registered User
    Join Date
    10-27-2017
    Location
    New York City
    MS-Off Ver
    2016
    Posts
    39

    Re: Excel Sheet Automatic Outlook Email

    Hmm, I tried to add that as you wrote it but it gave me a compiling error and highlighted the first line in that sub "Sub Mail_small_Text_Outlook()"

    Is there any additional syntax that I need to include?

    Thanks.

  6. #6
    Valued Forum Contributor than_gold's Avatar
    Join Date
    10-17-2017
    Location
    Coimbatore India
    MS-Off Ver
    Office 365
    Posts
    646

    Re: Excel Sheet Automatic Outlook Email

    not sure, can u post the whole code please?

  7. #7
    Registered User
    Join Date
    10-27-2017
    Location
    New York City
    MS-Off Ver
    2016
    Posts
    39

    Re: Excel Sheet Automatic Outlook Email

    Here is how it appears after I include the Range function. I tried it with and without quotes around "Range".

    Please Login or Register  to view this content.

  8. #8
    Valued Forum Contributor than_gold's Avatar
    Join Date
    10-17-2017
    Location
    Coimbatore India
    MS-Off Ver
    Office 365
    Posts
    646

    Re: Excel Sheet Automatic Outlook Email

    Please Login or Register  to view this content.
    You missed this part.

  9. #9
    Registered User
    Join Date
    10-27-2017
    Location
    New York City
    MS-Off Ver
    2016
    Posts
    39

    Re: Excel Sheet Automatic Outlook Email

    Ahh got it, thank you very much! That worked.

  10. #10
    Valued Forum Contributor than_gold's Avatar
    Join Date
    10-17-2017
    Location
    Coimbatore India
    MS-Off Ver
    Office 365
    Posts
    646

    Re: Excel Sheet Automatic Outlook Email

    You are welcome...& feel free to add rep if my comments assists you..

  11. #11
    Registered User
    Join Date
    10-27-2017
    Location
    New York City
    MS-Off Ver
    2016
    Posts
    39

    Re: Excel Sheet Automatic Outlook Email

    @than_gold

    If I could ask you one more thing about this, what would I do if I wanted to make the cell references dynamic? So if I had a list of all of the information that I wanted to include in the body, but instead of just referencing Row 7 then the email would send with the information in that specific row anytime that row was checked off?

    Thanks again!

  12. #12
    Valued Forum Contributor than_gold's Avatar
    Join Date
    10-17-2017
    Location
    Coimbatore India
    MS-Off Ver
    Office 365
    Posts
    646

    Re: Excel Sheet Automatic Outlook Email

    Yes, it is possible & you can do that. As you mentioned it will pick the data in those cells, which ever you mentioned in the code.

+ 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. Get Excel to send automatic email to outlook to attention an action
    By Lesawpm in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-09-2013, 08:09 AM
  2. Can Excel can send automatic Email using Outlook?
    By gaurav1018 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-17-2013, 02:29 AM
  3. Can excel send automatic email to outlook ?
    By ronybony in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-10-2013, 02:23 AM
  4. Outlook folderid automatic email
    By wedwards in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 12-04-2012, 12:08 PM
  5. Can excel send an automatic email via outlook? It get's a lot more complex...
    By BGibbons92 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-27-2012, 05:07 PM
  6. Can excel send automatic email to outlook
    By gurj_sandhu in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 04-27-2012, 02:46 AM
  7. Automatic Email Alerts based on due date in Excel Via Outlook
    By lcmerten in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-24-2011, 03:32 AM

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