Hi

I hope that someone can help me. I want to use a macro to send a form (using
Outlook 2007) created in Excel 2007 (which has the save/save as function
disabled and is read only) once a user has completed it.

I would like:-

The email subject line to include text and also to pick up information
within a cell in the spreadsheet.

The email body to include text and also to pick up information in cells from
within the spreadsheet.

The message with the form attached to be sent to an unchanging e-mail
address together with two other email addresses that are picked up from cells
within the form. Also to CC another user with the email address picked up
from a cell within the form.

I do not want to use a routing slip as this automatically inserts text into
the message which will confuse some of my users(!).

I hope that this makes sense.

iansmigger

On Nov 3, 5:03*am, iansmigger
wrote:
Hi

I hope that someone can help me. I want to use a macro to send a form (using
Outlook 2007) created in Excel 2007 (which has the save/save as function
disabled and is read only) once a user has completed it.

I would like:-

The email subject line to include text and also to pick up information
within a cell in the spreadsheet.

The email body to include text and also to pick up information in cells from
within the spreadsheet.

The message with the form attached to be sent to an unchanging e-mail
address together with two other email addresses that are picked up from cells
within the form. Also to CC another user with the email address picked up
from a cell within the form.

I do not want to use a routing slip as this automatically inserts text into
the message which will confuse some of my users(!).

I hope that this makes sense.

iansmigger

Hi,

Start by searching Ron DeBruin on Google
Ron has extensive code samples posted on how to send email from Excel
Post your code back and we can tweak to pick up specific cell values

Regards,
goss

Excellent, I have managed to get it working as I wanted.

Thanks

iansmigger

"-goss" wrote:

On Nov 3, 5:03 am, iansmigger
wrote:
Hi

I hope that someone can help me. I want to use a macro to send a form (using
Outlook 2007) created in Excel 2007 (which has the save/save as function
disabled and is read only) once a user has completed it.

I would like:-

The email subject line to include text and also to pick up information
within a cell in the spreadsheet.

The email body to include text and also to pick up information in cells from
within the spreadsheet.

The message with the form attached to be sent to an unchanging e-mail
address together with two other email addresses that are picked up from cells
within the form. Also to CC another user with the email address picked up
from a cell within the form.

I do not want to use a routing slip as this automatically inserts text into
the message which will confuse some of my users(!).

I hope that this makes sense.

iansmigger

Hi,

Start by searching Ron DeBruin on Google
Ron has extensive code samples posted on how to send email from Excel
Post your code back and we can tweak to pick up specific cell values

Regards,
goss