+ Reply to Thread
Results 1 to 4 of 4

Selected range gets copied in .to instead of .body when i make macro to Outlook

  1. #1
    Registered User
    Join Date
    10-10-2015
    Location
    Stockholm
    MS-Off Ver
    Windows 7
    Posts
    16

    Selected range gets copied in .to instead of .body when i make macro to Outlook

    Hi!
    I made a macro that selects a certain range and copies it to an new Outlook mail. It works great when i have something written in .To but now I want the .To to be empty like the code ive written here.
    But when i do this all of the copied range gets pasted in the to space instead of the body of the email.

    Theres probably something really small im missing. Can someone help me?

    Please Login or Register  to view this content.
    Last edited by paz1987; 10-20-2015 at 07:16 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    10-05-2014
    Location
    Regina, SK Canada
    MS-Off Ver
    Excel for Mac 11
    Posts
    330

    Re: Selected range gets copied in .to instead of .body when i make macro to Outlook

    Perhaps use a space in the .to field??? Just a thought, not tried.
    Please Login or Register  to view this content.
    If this has been helpful, please click on the star at the left.

  3. #3
    Registered User
    Join Date
    10-10-2015
    Location
    Stockholm
    MS-Off Ver
    Windows 7
    Posts
    16

    Re: Selected range gets copied in .to instead of .body when i make macro to Outlook

    Nah that didnt work. Thanks thought. Didnt think of that hehe.

    Please Login or Register  to view this content.
    But i cant figure it out. It just say wrong all the time.

  4. #4
    Registered User
    Join Date
    10-10-2015
    Location
    Stockholm
    MS-Off Ver
    Windows 7
    Posts
    16

    Re: Selected range gets copied in .to instead of .body when i make macro to Outlook

    Still having this issue. Is there someone who can help?

+ 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. [SOLVED] Macro to transfer Selected Range to Outlook
    By JuneTwentyFourteen in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-24-2014, 05:42 AM
  2. Run-Time Error 4065 - Pasting Copied Data from Excel to Outlook Email Body
    By jtn260 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-25-2014, 11:03 AM
  3. [SOLVED] edit a macro that will limit the range of cells being copied in the email body
    By melody10 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 11-16-2013, 10:45 AM
  4. Excel VBA outlook - Range in mail body
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-25-2013, 06:33 AM
  5. VBA to select a Range of cells as Email Body In Outlook
    By TC922 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-16-2013, 11:06 AM
  6. Why does this export to outlook code not work when my body has a range name in it....
    By joshnathan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-18-2012, 07:53 AM
  7. Make paragraphs in body of outlook task created from Excel
    By raehippychick in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-31-2008, 06:54 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