Loading
Ozgrid Excel Help & Best Practices Forums

Excel Training / 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...

    Code:
    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...

    Code:
    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 1 users browsing this thread. (0 members and 1 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, 01:05
  2. Send Email With Worksheet As Body
    By SteveAB in forum Excel and/or Email Help
    Replies: 5
    Last Post: July 25th, 2007, 06:44
  3. Send Email & Write to Email Body
    By jillyb in forum EXCEL HELP
    Replies: 2
    Last Post: November 11th, 2006, 04: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, 02:49
  5. olMail.Body email import single lines
    By tonyd321 in forum Excel and/or Email Help
    Replies: 7
    Last Post: June 29th, 2005, 09: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