Hello all, I hope I'm posting this in the correct place and am grateful
for any assistance anyone can offer.

I've been asked to setup a Purchase Order form which I'm hoping I can
do in Excel although I'm not sure how much it is capable of.

I've setup a basic layout and done some basic stuff like having it auto
insert the correct date when it's opened and created a button to clear
the sheet etc.

Now what I want is a button or a series of buttons that when pressed
will, Print the sheet, Email the sheet (Possible?) to someone (same
person everytime), clear the sheet, increase the Order No' by 1 and
then save it ready for the next person.

Now I know how to record a macro to save, print and clear the sheet
when pressed but no idea how to the email/number increase. Anyone know
how or if this at all possible, also is it all possible with 1 button
click?

Would I be better off trying to do this in Access or something?

Once again, I appreciate any assistance and I hope this makes some
sense to somone.


--
Fordy
------------------------------------------------------------------------
Fordy's Profile: http://www.excelforum.com/member.php...o&userid=30365
View this thread: http://www.excelforum.com/showthread...hreadid=500195

Hi Fordy

In the macro you can use this line to increase the number

Sheets("sheet1").Range("A1").Value = Sheets("sheet1").Range("A1").Value + 1

You can use to mail the activesheet
http://www.rondebruin.nl/mail/folder1/mail2.htm


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


"Fordy" wrote in message
...

Hello all, I hope I'm posting this in the correct place and am grateful
for any assistance anyone can offer.

I've been asked to setup a Purchase Order form which I'm hoping I can
do in Excel although I'm not sure how much it is capable of.

I've setup a basic layout and done some basic stuff like having it auto
insert the correct date when it's opened and created a button to clear
the sheet etc.

Now what I want is a button or a series of buttons that when pressed
will, Print the sheet, Email the sheet (Possible?) to someone (same
person everytime), clear the sheet, increase the Order No' by 1 and
then save it ready for the next person.

Now I know how to record a macro to save, print and clear the sheet
when pressed but no idea how to the email/number increase. Anyone know
how or if this at all possible, also is it all possible with 1 button
click?

Would I be better off trying to do this in Access or something?

Once again, I appreciate any assistance and I hope this makes some
sense to somone.


--
Fordy
------------------------------------------------------------------------
Fordy's Profile: http://www.excelforum.com/member.php...o&userid=30365
View this thread: http://www.excelforum.com/showthread...hreadid=500195