Creating multiple messages from spreadsheet
 

Hi,

In my office we currently, on a daily basis, using the Mail Merge
function of Word to e-mail customer bookings from our call centre to
the relevant branches. This makes use of an Excel spreadsheet with the
data to merge. However, one problem is that the branch managers would
really like to have the customer's name as part of the subject line
e.g. "Booking Information - <<CUSTOMERNAME". This is not possible
with Office 2000 Word e-mail merge function.

It has been suggested to me before that this is possible in VBA. I am
not a novice to programming - at all. However, I am not ver
proficient in VBA and its Ins & Outs.

What I need to be able to do is (from Outlook, Word or Excel - whatever
makes it easiest) create an e-mail message object (I think there is
such a class) and then build up the content in the message using each
row in the Excel spreadsheet.

I dont mind building the message up programatically i.e. (not VB syntax
I know):

message.line.write("Customer Booking for " +
Excel.row[i].cell[2].value);

and

message.subject = "Booking Notice: " + Excel.row[i].cell[2].value;

Obviously I would need this to loop until it comes to the last row in
the spreadsheet.

Any help with this would be greatly appreciated...

Mark Young