I need assistance in VBA coding to create an email message from a workbook.



In the workbook combo-boxes, check-boxes and option objects will be used for
the user to make selections and on a separate sheet the content of the
email message will be generated. After the user have finished the request, a
command button must be clicked, when clicked a "print-area range" must be
copied and pasted in Microsoft Outlook as the message content, but the
addressee must be predetermined and the message automatically be sent and
put in the outbox to be send on the next time the operator connects.



I have tried using the Record a Macro in Excel 2000, but it does not work.



Could somebody help me with the VBA code for such procedure?

Tobie

You will find it in

http://msdn.microsoft.com/library/de...odc_xlmail.asp



Tobie Hanekom wrote:

I need assistance in VBA coding to create an email message from a workbook.



In the workbook combo-boxes, check-boxes and option objects will be used for
the user to make selections and on a separate sheet the content of the
email message will be generated. After the user have finished the request, a
command button must be clicked, when clicked a "print-area range" must be
copied and pasted in Microsoft Outlook as the message content, but the
addressee must be predetermined and the message automatically be sent and
put in the outbox to be send on the next time the operator connects.



I have tried using the Record a Macro in Excel 2000, but it does not work.



Could somebody help me with the VBA code for such procedure?

Tobie

Two sources of information:


Ron de Bruin's site

http://www.rondebruin.nl/sendmail.htm


Dick Kusleika's site

http://www.dicks-clicks.com/excel/olSending.htm

--
Regards,
Tom Ogilvy




"Tobie Hanekom" wrote in message
...
I need assistance in VBA coding to create an email message from a
workbook.



In the workbook combo-boxes, check-boxes and option objects will be used
for
the user to make selections and on a separate sheet the content of the
email message will be generated. After the user have finished the request,
a
command button must be clicked, when clicked a "print-area range" must be
copied and pasted in Microsoft Outlook as the message content, but the
addressee must be predetermined and the message automatically be sent and
put in the outbox to be send on the next time the operator connects.



I have tried using the Record a Macro in Excel 2000, but it does not work.



Could somebody help me with the VBA code for such procedure?

Tobie