I
iansmigger
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
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