I may be a bit out of my league here, but what I'm trying to do is to
insert buttons in my excel file that :
1) open outlook and start a new message to a certain email-address (so
far so good, this part works)
2) add a default text-body
3) attach the file in which this button is,
4) after first saving the changes (can this saving be done without
saving it to an actual location, but just saving it it the temp
folder?)
I've seen it work (without the attachment) on my previous job, but I
can't find out how.
In advance, many thanks!


--
Jufa
------------------------------------------------------------------------
Jufa's Profile: http://www.excelforum.com/member.php...o&userid=30742
View this thread: http://www.excelforum.com/showthread...hreadid=504066

Hi Jufa

4) after first saving the changes (can this saving be done without
saving it to an actual location, but just saving it it the temp
folder?)

Do you want to save a copy of the file and send that
Am I correct ?


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Jufa" wrote in message
...

I may be a bit out of my league here, but what I'm trying to do is to
insert buttons in my excel file that :
1) open outlook and start a new message to a certain email-address (so
far so good, this part works)
2) add a default text-body
3) attach the file in which this button is,
4) after first saving the changes (can this saving be done without
saving it to an actual location, but just saving it it the temp
folder?)
I've seen it work (without the attachment) on my previous job, but I
can't find out how.
In advance, many thanks!


--
Jufa
------------------------------------------------------------------------
Jufa's Profile: http://www.excelforum.com/member.php...o&userid=30742
View this thread: http://www.excelforum.com/showthread...hreadid=504066

Yep,
Maybe I should give a bit more detail.
The idea is to create a request form that has to go through a flow of
approvals. Person 1 initiates, saves the file on his hard drive and
forwards it to approver 1. Approver 1 approves and mails it to Approver
2 etc. I want to facilitate the mailing process by adding a hyperlink
next to the approval line where he simply marks "OK" (please have mercy
on me. I realise there must be better ways to organise this, but for
starters, this is the way I would like to set it up and there's a nice
learning process here. I will probably be posting questions on secure
digital signatures quite soon:)). Clicking the hyperlink should open
mail, set the right "to" (approver 2), add a subject, add text of the
mail ("please find attached for your approval bla bla...") and attach
the excel file. In order to make sure that the approval of the sender
is included, I would like it to autosave before leaving (I'm not even
sure that this is neccessary as excel might forward the version as it
is at the moment of attaching?).
Hope this sheds more light over my problem.

Greetings


--
Jufa
------------------------------------------------------------------------
Jufa's Profile: http://www.excelforum.com/member.php...o&userid=30742
View this thread: http://www.excelforum.com/showthread...hreadid=504066

Hi Jufa

The code to do this is on my site
Try a few examples first
http://www.rondebruin.nl/sendmail.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Jufa" wrote in message
...

Yep,
Maybe I should give a bit more detail.
The idea is to create a request form that has to go through a flow of
approvals. Person 1 initiates, saves the file on his hard drive and
forwards it to approver 1. Approver 1 approves and mails it to Approver
2 etc. I want to facilitate the mailing process by adding a hyperlink
next to the approval line where he simply marks "OK" (please have mercy
on me. I realise there must be better ways to organise this, but for
starters, this is the way I would like to set it up and there's a nice
learning process here. I will probably be posting questions on secure
digital signatures quite soon:)). Clicking the hyperlink should open
mail, set the right "to" (approver 2), add a subject, add text of the
mail ("please find attached for your approval bla bla...") and attach
the excel file. In order to make sure that the approval of the sender
is included, I would like it to autosave before leaving (I'm not even
sure that this is neccessary as excel might forward the version as it
is at the moment of attaching?).
Hope this sheds more light over my problem.

Greetings


--
Jufa
------------------------------------------------------------------------
Jufa's Profile: http://www.excelforum.com/member.php...o&userid=30742
View this thread: http://www.excelforum.com/showthread...hreadid=504066

Code is working just fine. Thanks a lot!
So I see you can't add a body or cc or bcc, but is there any way that I
can enter 2 addresses in the "to line"?
Are there editors or wizards or something to create VBA code or is it
all just hard input?

In any case, thanks for the help!


--
Jufa
------------------------------------------------------------------------
Jufa's Profile: http://www.excelforum.com/member.php...o&userid=30742
View this thread: http://www.excelforum.com/showthread...hreadid=504066

Hi Jufa

So I see you can't add a body or cc or bcc, but is there any way that I
If you use the Outlook object model code from my site you can use it

can enter 2 addresses in the "to line"?
Click on the Tips link that you find on each page


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Jufa" wrote in message ...

Code is working just fine. Thanks a lot!
So I see you can't add a body or cc or bcc, but is there any way that I
can enter 2 addresses in the "to line"?
Are there editors or wizards or something to create VBA code or is it
all just hard input?

In any case, thanks for the help!


--
Jufa
------------------------------------------------------------------------
Jufa's Profile: http://www.excelforum.com/member.php...o&userid=30742
View this thread: http://www.excelforum.com/showthread...hreadid=504066