Ossie,
I have 170 email addressees. I need to advise each of them the items that
require their attention - adderssees and items are in an Excel file - where
column A is the addressee and column I is the list of numbers that requires
the attenion of each addressee. e.g an addressee might have 8 items that need
attention, so the email would be to the one addressee, and the body of the
email would list the 8 items that need attention. I would be over the moon if
it was possible to addreess emails as well as including the lsit of items
that requires the addressee's attention, in the body of the email...

Hope this clarifies
Chippa
--
Chippa


"OssieMac" wrote:

Hi again Chippa,

You say "can input the email address individually". Therefore I am still
unsure what you really want help with. You should be able to simply copy the
block of data from excel and paste it into your email.

--
Regards,

OssieMac


"Chippa" wrote:

Ossie Mac,
"No", it's not actually a letter - I am actually wanting to email the
addresseea, but can input the email address individually, and "No", I have no
idea about macros for emailing off lists!!.
"No", I don't know how to copy and install the macro.
I am using Excel 2003.
"Yes", the Addressee's name full all rows which have activities assigned to
that addressee.
As per first stament, I am looking to send emails with tht body of text
incorporating the merged fields; and in resposne to the last question, "No",
I wouldne't need a saved copy as file as they will go out as emails.
Thanks for your help and quick response...
Cheers
Chippa....

--
Chippa


"OssieMac" wrote:

Hi Chippa,

Need some clarification of exactly what you want.

Am I correct when you say a letter you mean a Word document?

Are you looking for macro code to do this? (I don't think there is any other
way). If so, do you know how to copy and install the macro or do you need
instructions on how to do so?

What version of Excel and Word are you using?

Is the addressee's name repeated in column A for the number of rows that
hold activities or are the in-between addressee's rows blank?

Do you intend having a template for the entire letter and just have the
excel data inserted so that the documents are all created and printed
automatically or do you want to edit each document after the addressee and
activities are inserted? If the latter, you would need to click a button
after each document is completed to start the next document.

Do you want the documents automatically saved? If so, can they be saved with
the addressee's name as the file name?


--
Regards,

OssieMac