Outlook Appointment with Excel VBA (range as body of message)

[Ksenofon111]

Hi Everyone,

i found this code from ExtendOffice to help me set Appointments/reminders in Outlook from Excel.

Please Login or Register  to view this content.

I want this code to send a range (or a dynamic range) of cells as the body of the appointment message not just the value of one cell (xRg.Cells(I, 7).Value) , but i have no idea how to do this. Can anyone help me?

the range can be displayed as is or as an image, which ever is easier.

Thank you!

[6StringJazzer]

a range (or a dynamic range) of cells as the body of the appointment message

Which range do you want to use as the body text? It's not evident from the file. Please include an example of what this data would look like.

[Ksenofon111]

Sorry about that

The range in this case would be =A7:G17

thank you

[6StringJazzer]

Something like this to start, to replace the line you currently have assigning xOutItem.Body. But you will have to revise it to the desired format:

Please Login or Register  to view this content.