Oracle to Excel to Eudora/Outlook
 

hi, i don't even know if this is possible or if this is
the place to post, but this is my dilemna:

i have a large amount of data that i took for oracle and
put into excel. different sections of this info has to be
sent to different people. i have a standard letter that
goes out to these people but 4 items in this letter
changes in each item (which would be the stuff from
oracle).
is there anyway possible that i can set up a macro, mail
merge or whatever so that excel automatically takes the
information from the colums, puts it into the right fields
and executes the email to the assigned person.

ex.
name Acct# Award# End Date
john doe 12345 15A7 12/15/03
amy smith 54321 24C9 12/17/03

standard email:
acct#:________________
award#: ______________

please know that the referenced expires on: _________
please complete all necessary paperwork. thank you


i need the information to fill into those blanks
automatically. and then send it to the person. if anyone
can help or give any type of suggestions, please let me
know. thanks in advance.

Oracle to Excel to Eudora/Outlook
 

Jackson

Start here

www.rondebruin.nl
www.dicks-clicks.com (Outlook only)

These will show you how to make an email. Post back if you have follow up
questions.

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"Jackson" wrote in message
...
hi, i don't even know if this is possible or if this is
the place to post, but this is my dilemna:

i have a large amount of data that i took for oracle and
put into excel. different sections of this info has to be
sent to different people. i have a standard letter that
goes out to these people but 4 items in this letter
changes in each item (which would be the stuff from
oracle).
is there anyway possible that i can set up a macro, mail
merge or whatever so that excel automatically takes the
information from the colums, puts it into the right fields
and executes the email to the assigned person.

ex.
name Acct# Award# End Date
john doe 12345 15A7 12/15/03
amy smith 54321 24C9 12/17/03

standard email:
acct#:________________
award#: ______________

please know that the referenced expires on: _________
please complete all necessary paperwork. thank you


i need the information to fill into those blanks
automatically. and then send it to the person. if anyone
can help or give any type of suggestions, please let me
know. thanks in advance.