+ Reply to Thread
Results 1 to 4 of 4

Excel VBA to Create Outlook Appointment - .Body blank

  1. #1
    Forum Contributor
    Join Date
    11-15-2011
    Location
    UK
    MS-Off Ver
    Excel 2013
    Posts
    163

    Excel VBA to Create Outlook Appointment - .Body blank

    Hi All,

    Im trying to create an outlook appointment from Excel Sheet.

    Everything works fine apart from the .Body attribute which does not copy across to the appointment form. I have a similar command that generates an email and fills in email .Body no problem. Any ideas what might be wrong?

    Please Login or Register  to view this content.

  2. #2
    Forum Contributor
    Join Date
    11-15-2011
    Location
    UK
    MS-Off Ver
    Excel 2013
    Posts
    163

    Re: Excel VBA to Create Outlook Appointment - .Body blank

    Do I need to convert to HTML?

  3. #3
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: Excel VBA to Create Outlook Appointment - .Body blank

    Hi, rtcwlomax,

    it would be a good idea to remove On Error Resume Next as any error isnīt displayed.

    Please check (your code]
    Please Login or Register  to view this content.
    and try using
    Please Login or Register  to view this content.
    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  4. #4
    Forum Contributor
    Join Date
    11-15-2011
    Location
    UK
    MS-Off Ver
    Excel 2013
    Posts
    163

    Re: Excel VBA to Create Outlook Appointment - .Body blank

    Well that is just embarrassing...how I didnt see that.

    Is there a spell checker plugin for excel as I obviously need one!

    Thank you Holger.

+ 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. Create Outlook Appointment in Excel VBA
    By newbie28 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-23-2011, 10:27 AM
  2. [SOLVED] Is this possible?-Create a button in excel that can open an outlook appointment?
    By Movieman in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM

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