Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 4 of 4

Thread: tyring to send multiple lines in the body of an outlook email...

  1. #1
    Join Date
    12th December 2003
    Posts
    714

    tyring to send multiple lines in the body of an outlook email...

    my email from excel works great...

    VB:
    With objMail 
        .To = myemail 
        .Subject = "Note from Production" 
         '.Body = "...."
         '.Body = ",,,,"
        .Body = ">>>>" 
        etc. 
    
    
    but i want to send multiple (and different) lines in the body of the email, but i can seemingly only send one...

    ???

    thank you...

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    18th May 2005
    Posts
    44

    Re: tyring to send multiple lines in the body of an outlook email...

    VB:
    Dim sMsgBody As String 
     
    sMsgBody = "HI mjschukas" & vbcr & vbcr 
    sMsgBody = sMsgBody & "Just wanted to let you know" & vbcr 
    sMsgBody = sMsgBody & "This is how you would do it." & vbcr 
    sMsgBody = sMsgBody &  "The vbcr means skip a line, and if " & vbcr 
    sMsgBody = sMsgBody &  " you place to of them you will skip 2 lines." & vbcr & vbcr 
    sMsgBody = sMsgBody & "Thank you," & vbcr & vbcr 
    sMsgBody = sMsgBody & "John" 
     
    .body = sMsgBody 
    
    

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    7th March 2013
    Posts
    3

    Re: tyring to send multiple lines in the body of an outlook email...

    Hi,

    I am looking for help to finish my vb email project. I am writing code in VB for sending email, however i am would like to make some text bold in email body. I would like to add FROM filed in email which should pick up FROM address from email code.
    Any help would appreciated.

    Regards
    Abi

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    7th March 2013
    Posts
    3

    Re: tyring to send multiple lines in the body of an outlook email...

    Hi,

    I am looking for help to finish my vb email project. I am writing code in VB for sending email, however i am would like to make some text bold in email body. I would like to add FROM filed in email which should pick up FROM address from email code.
    Any help would appreciated.

    Regards
    Abi

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 2 users browsing this thread. (0 members and 2 guests)

Possible Answers

  1. Send Email Via Outlook With Body Text
    By jimbean in forum Excel and/or Email Help
    Replies: 2
    Last Post: August 22nd, 2007, 00:05
  2. Send Email With Worksheet As Body
    By SteveAB in forum Excel and/or Email Help
    Replies: 5
    Last Post: July 25th, 2007, 05:44
  3. Send Email & Write to Email Body
    By jillyb in forum EXCEL HELP
    Replies: 2
    Last Post: November 11th, 2006, 03:21
  4. email active range on worksheet to body of outlook 2003 email
    By mjschukas in forum Excel and/or Email Help
    Replies: 4
    Last Post: January 31st, 2006, 01:49
  5. olMail.Body email import single lines
    By tonyd321 in forum Excel and/or Email Help
    Replies: 7
    Last Post: June 29th, 2005, 08:03

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
  •  
porno