Excel function sending appointment

[lakey13]

Excel 2007

I am using some excel code for a function that will send an appointment from excel to groupwise (emailing program used by Novell)

The code is working, however I do not know how to send arguments from the spreadsheet

Here is the code as it sits now:

Please Login or Register  to view this content.

I want the function to take information from the spreadsheet I've attached when sending the appt:

for example:
objDraftMsg.StartDate would be the date showing in column G (Event Date)
objDraftMsg.Subject would be column B (H Number)
objDraftMsg.Recipients.AddByDisplayName would be column M (Analyst)

the body of the appt would consist of a template:

There is a Teleconference Event scheduled for the following:
Unit: 484401800 (column c)
Location: 15 Fish St (column d)
Teleconference: 1-555-234-5545
Entry code: 622335#
Please phone in five minutes prior to the indicated start time.


How do you put the variables such as describe through to an appt?

[Leith Ross]

Hello lakey13,

Your post does not comply with Rule 3 of our Forum RULES. I added them for you this time. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here