3 things to learn

[David Gerstman]

I have 3 chores at work and I was wondering what the best resources are for
learning and/or mastering them.
1) Scheduling. Specifically, we have a schedule (actually a list of dates
and names corresponding to those dates) for doing a certain task in Excel.
I'd like to automate the process of reading the spreadsheet and reminding the
people when it is their turn. I assume that I would either program this in
Outlook using an Excel object or in Excel with an Outlook object.
2) Creating forms. Is there any way of expediting the process of creating
forms?
3) Related to 2): what is the best process of learning the ins and outs of
MailMerge?

Are there good books or other tutorials out there for those tasks. As it is
I am a fair macro programmer in Excel. While I've also been able to do some
limited macro programming in Word, I haven't been as comfortable. Finally is
there a really good book on VBA programming for each different Office
application?

Thank you,

 

[Milly Staples [MVP - Outlook]]

1. Use Outlook - its reminders are very handy.
2. Forms for what purpose? Outlook Forms? Word Templates?
3. Try F1 help or this site:
http://www.slipstick.com/contacts/startletter.htm and
http://www.slipstick.com/addins/mail.htm#massmail

--
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.

After furious head scratching, David Gerstman asked:

| I have 3 chores at work and I was wondering what the best resources
| are for learning and/or mastering them.
| 1) Scheduling. Specifically, we have a schedule (actually a list of
| dates and names corresponding to those dates) for doing a certain
| task in Excel. I'd like to automate the process of reading the
| spreadsheet and reminding the people when it is their turn. I assume
| that I would either program this in Outlook using an Excel object or
| in Excel with an Outlook object. 2) Creating forms. Is there any way
| of expediting the process of creating forms?
| 3) Related to 2): what is the best process of learning the ins and
| outs of MailMerge?
|
| Are there good books or other tutorials out there for those tasks. As
| it is I am a fair macro programmer in Excel. While I've also been
| able to do some limited macro programming in Word, I haven't been as
| comfortable. Finally is there a really good book on VBA programming
| for each different Office application?
|
| Thank you,

 

[David Gerstman]

1) I would be very happy to use Outlook and reminders. Is there a way to
automate the process. (I wouldn't mind setting them up manually but I'm staff
with no supervisory authority. Having the reminder coming from me wouldn't be
appreciated. If I could automate the process and give it to my boss, that
would be a different matter.)
2) Either kind of form.
3) Thank you.

 

[Milly Staples [MVP - Outlook]]

1. You need to explain in more detail exactly what you wish to accomplish
with the reminders/tasks from Excel - perhaps cross-posting to an Outlook
programming group will yield more assistance. Also, include if you want the
reminders to fire from the personal folders calendar, exchange calendar, or
public folders calendar.

2. For Outlook items forms designing, use Tools->Forms->Design a
form->Select the form type and use F1 help extensively. You can also use the
information here for basic assistance - I really suggest purchasing a book
dedicated to forms design if your needs are more than basic.

http://www.outlook-tips.net/howto/forms_design.htm


--
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.

After furious head scratching, David Gerstman asked:

| 1) I would be very happy to use Outlook and reminders. Is there a way
| to automate the process. (I wouldn't mind setting them up manually
| but I'm staff with no supervisory authority. Having the reminder
| coming from me wouldn't be appreciated. If I could automate the
| process and give it to my boss, that would be a different matter.)
| 2) Either kind of form.
| 3) Thank you.
|
| "Milly Staples [MVP - Outlook]" wrote:
|
|| 1. Use Outlook - its reminders are very handy.
|| 2. Forms for what purpose? Outlook Forms? Word Templates?
|| 3. Try F1 help or this site:
|| http://www.slipstick.com/contacts/startletter.htm and
|| http://www.slipstick.com/addins/mail.htm#massmail
||
|| --Â
|| Milly Staples [MVP - Outlook]
||
|| Post all replies to the group to keep the discussion intact. Due to
|| the (insert latest virus name here) virus, all mail sent to my
|| personal account will be deleted without reading.
||
|| After furious head scratching, David Gerstman asked:
||
||| I have 3 chores at work and I was wondering what the best resources
||| are for learning and/or mastering them.
||| 1) Scheduling. Specifically, we have a schedule (actually a list of
||| dates and names corresponding to those dates) for doing a certain
||| task in Excel. I'd like to automate the process of reading the
||| spreadsheet and reminding the people when it is their turn. I assume
||| that I would either program this in Outlook using an Excel object or
||| in Excel with an Outlook object. 2) Creating forms. Is there any way
||| of expediting the process of creating forms?
||| 3) Related to 2): what is the best process of learning the ins and
||| outs of MailMerge?
|||
||| Are there good books or other tutorials out there for those tasks.
||| As
||| it is I am a fair macro programmer in Excel. While I've also been
||| able to do some limited macro programming in Word, I haven't been as
||| comfortable. Finally is there a really good book on VBA programming
||| for each different Office application?
|||
||| Thank you,