Send data from Excel to Microsoft Outlook.

[taylo40]

Hello,

I wonder whether anybody can help. I have a excel spreadsheet that contains:-

Column A = Persons email address
Column B = Bonus this month
Column C = Bonus YTD

I also have a pro forma excel spreadsheet that states about the bonus scheme.

I would like to create a macro that Excel takes the data from Excel for one person and inserts it into the email. The macro will then send the email out. The macro will then repeat until all of the emails have been issued.

Any ideas ?

Regards,

Jamie

 

[xlbo]

yup - lots - what have you tried so far ??

Rgds, Geoff

Three things are certain. Death, taxes and lost data. DPlank is to blame

Please read FAQ222-2244 before you ask a question

 

[jimp56]

excel->word->mail merge?

 

[taylo40]

Hello Again,
Sometime ago, I cam across the following website:-

http://j-walk.com/ss/excel/tips/tip86.htm

This shows what I mean, the only difference is that you need to type the email text within the VBA code so it is a bit limiting.

My next question is, can you type the email in Outlook (using formatting) and in the message, reference variables that relate to the Excel data ?

Regards,


Jamie

 

[xlbo]

nope. You do the formatting in code using the HTMLbody property of the mailITEM using standard HTML tags eg

HTMLbody = "This would be <br><br> an example of a line break"

Rgds, Geoff

Three things are certain. Death, taxes and lost data. DPlank is to blame

Please read FAQ222-2244 before you ask a question