Email body macro problem

[sjbtax]

Hi,

I am trying to code a macro to automatically create an email to confirm an appointment from the details of the appointment made. When the appointment is selected or open the macro is run and the email populates with the information that I need. As part of the email I confirm the Appointment Location (either at the address specified in the location field or defaulting to our office address if the location field is left blank)

I have confirmed that the macro is returning the correct details by displaying them in a MsgBox, but I cannot get the macro to place the correct location address in the body of the email.

Can anybody help with where I am going wrong.

Please Login or Register  to view this content.

Moderators note:

1. you were almost there to mark the thread solved. After you go into edit on teh 1st post, go into advanced, and scroll down a but til you see the pull-down that says "Prefix" and chanfge that to solved

2. for future reference, please use code tags around your VBA code, it makes them easier to read and copy

[scott.s.fower]

you have to define AppointLocation before the .body argument so excel knows that AppointLocation is not ""

[sjbtax]

Thanks Scott,

Makes perfect sense... Of course.

I feel like such a newb!