Gjones, a lil bit more clarification

  • Thread starter Thread starter Jackson
  • Start date Start date
J

Jackson

hi,
yesterday you told me i could use outlook with a DSN to
hit the database directly, and then of course the mail
merge? so my question is, whats a DSN?
 
Open DataBase Connectivity (I think).
DSNs are Data Source Names; drivers that allow applications to interface to
each other.
Looking back at your original question, it seems that all you need is a VBA
(Visual Basic) macro that you can run from the Excel spreadsheet, to go
through the list of data and for each e-mail address, construct the message
body and send it. However, I can't see how to send e-mail from VBA, someone
else will have to tackle this part.
 
thank you very much for you help, i just wanted to say
that first and foremost, but if you want to know my
original question before gjones offered help this was it:

-----------------------------------------------------------
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 <[email protected]> 12345 15A7 12/15/03
amy smith <[email protected]> 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.
-----------------------------------------------------------

that was my orginal question and then gjones told me about
the dsn option. if you have any suggestions or if you
think i'm going about it in the right way, i would truely
appreciate your advice. thanks in advance
-jackson
 
Back
Top