Re: Sending one mail to addresses from Excel file

It could be only text or text and a file. Though I don't mind adding the
text and file manually.
Thinking about it, some kind of procedure that puts every email address
together, separated by a semi colon, would enable me to past all the
addresses in the mail in one action.
Thanks,
John

"Ron de Bruin" <rondebruin@xxxxxxxxxxxx> schreef in bericht
news:Oi6bgWJRIHA.5976@xxxxxxxxxxxxxxxxxxxxxxx
Hi John

Do you want to send only text or a file ?


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


<johnie@xxxxxxxxxx> wrote in message
news:fkimam$28al$1@xxxxxxxxxxxxxxxxxxxxxx
I have an excel file with email addresses. Periodically I need to send all
of these these people an email, so I need one mail where the 'To' field is
filled with all the email addresses. What is the best way to automate
this? Can I perhaps make a macro in Excel that opens Outlook and creates
the mail?
Thanks for any help.
John


.

Relevant Pages

  • Re: Early fruits of my labour
    ... Two things came to mind when reading it; ... Have you looked at something like a macro preprocessor like m4? ... > ASCII, it might be easier to support with standard editors. ...
    (alt.lang.asm)
  • Re: Richard Teers Solaris book reviewed on Slashdot.org
    ... >> func ... to distinguish macro calls from function calls. ... and only recently changed my mind. ...
    (comp.unix.solaris)
  • Re: How do you get rid of the twisted Word paper-clip?
    ... You can also put this line in an AutoExec() macro ... If you don't have one yet, the entire macro would be ... On the Options tab uncheck the box beside Use the Office Assistant ... I focus my mind for the job and do it with pleasure. ...
    (microsoft.public.word.docmanagement)
  • Re: VBA problem to open a file which is allready opened
    ... of these small devils in mind, by helping me solve my VBA-problem: ... I try - and manage - to create a macro that copy a specified ... the macro in the case where this specified workbook is allready opened. ... SkipBlanks _ ...
    (microsoft.public.excel)
  • VBA problem to open a file which is allready opened
    ... of these small devils in mind, by helping me solve my VBA-problem: ... I try - and manage - to create a macro that copy a specified ... the macro in the case where this specified workbook is allready opened. ... SkipBlanks _ ...
    (microsoft.public.excel)