Include range of cells

Afternoon all i am trying to include a range of cells from A5 to H27 into the body of the email after the body text.

Please help.


Sub Send_to_DNN1()

Dim OutApp, OutMail As Object
Dim strto, strcc, strbcc, strsub, strbody As String

Set OutApp = CreateObject(“Outlook.Application”)

    Set OutMail = OutApp.CreateItem(0)

        strto = “”
        strsub = “Confirmation of Flex Routes OFD – ” & Date + 1
        strbody = “Hi all,” & vbNewLine & _
            ” ” & vbNewLine & _
            “Below is the wave plan for tomorrow. Volume estimated at ” & Range(“M11″).Value & ” (Flex adjusted) with an SPR of ” & Range(“N9”).Value & “.” & vbNewLine & _
            ” ” & vbNewLine & _
            “Flex Routes Planned to ” & Range(“O13”).Value & “.” & vbNewLine & _
            ” “

        With OutMail
            .To = strto
            .Subject = strsub
            .Body = strbody

        End With
        On Error Resume Next

Set OutMail = Nothing
Set OutApp = Nothing
End Sub

By: Rob

19 thoughts on “Include range of cells

  1. sling tv

    We are a group of volunteers and starting a new scheme in our community.
    Your site offered us with valuable information to work on. You’ve
    done a formidable job and our entire community will be thankful
    to you.

  2. vurtil opmer

    Im not positive where you are getting your information, but good topic. I needs to spend a while studying much more or figuring out more. Thanks for wonderful info I was looking for this info for my mission.

  3. sling tv

    I think the admin of this website is actually
    working hard in favor of his site, for the reason that
    here every information is quality based data.

  4. sling tv

    Usually I don’t learn article on blogs, however I wish to say that this write-up very forced me to
    check out and do it! Your writing style has been surprised me.
    Thank you, very great post.


    Good post. I learn something totally new and challenging on blogs I stumbleupon every day.
    It will always be interesting to read through articles
    from other authors and use something from other web sites.

  6. quest bars cheap

    Great beat ! I would like to apprentice while you amend your site, how could i subscribe for a blog site?
    The account aided me a acceptable deal. I had been tiny bit acquainted of this your broadcast provided bright clear idea

  7. ps4 games

    I really like what you guys are usually up too. Such clever work and reporting!
    Keep up the amazing works guys I’ve added you guys to my


    Aw, this was an exceptionally good post. Taking
    the time and actual effort to produce a top notch article…
    but what can I say… I put things off a whole lot and don’t
    manage to get anything done.

Comments are closed.