Results 1 to 4 of 4

Thread: Email using 2 cells
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    May 2007
    Location
    Canada
    Posts
    1,577
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Email using 2 cells

    Is it possible to include two cells in an email row as below eg. "T1" and "Z1"?

    Code:
         .To = Sheets("Data").Range("T1").Value
    Excel 2010

  2. #2
    Board Regular
    Join Date
    May 2007
    Location
    Canada
    Posts
    1,577
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Email using 2 cells

    bump
    Excel 2010

  3. #3
    MrExcel MVP FormR's Avatar
    Join Date
    Aug 2011
    Location
    UK
    Posts
    6,089
    Post Thanks / Like
    Mentioned
    24 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Email using 2 cells

    Have you tried:

    Code:
    .To = Sheets("Data").Range("T1").Value & ";" & Sheets("Data").Range("Z1").Value
    [code]your code[/code]

  4. #4
    Board Regular
    Join Date
    May 2007
    Location
    Canada
    Posts
    1,577
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Email using 2 cells

    No I haven't. Mainly because I was not sure how to do it. Thanks again for your help FormR. You've been a great help this week.
    Excel 2010

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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