Mulitple Listing of items within the single mail merge letter

[Chippa]

Column A of my spreadsheet has the addressee's name. Column F has the
activity numbers that each addressee is resopnsible for. I want to create one
letter to each addressee - "Dear <<column A>>" and then list all the
addressee's activities from column F in the body of the letter "Activity
Numbers: <<Activity Number - Row 1>>, <<Activity Number- Row 2>>" etc.

Anyway that you can assist me?

Cheers

 

[OssieMac]

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?

 

[Chippa]

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....

 

[OssieMac]

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.

 

[Chippa]

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

 

[OssieMac]

OK Chippa. I can do this as an Excel macro. I can give you step by step
instructions for installing the macro; it is not difficult.

Can only do using Outlook as your email program (not possible with Outlook
Express). If you are not already using Outlook as your email program then you
will need to set it up. Will that be a problem? If that is not possible then
there is no point in my going any further with it.

The addresses in column A. What format are they in? Are they names that
match the names in your email address book or are they actual email addresses?

If I write the macro, you will have to remain with the computer and
authorize the sending of every one of the emails. Reason for this is Windows
security to ensure that programs are not sending emails without your
knowledge. There is no way that I know of to bypass this security.

Let me know if the above is what you would like.