| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Mulitple Listing of items within the single mail merge letter
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 -- Chippa |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Mulitple Listing of items within the single mail merge letter
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Mulitple Listing of items within the single mail merge letter
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Mulitple Listing of items within the single mail merge letter
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Mulitple Listing of items within the single mail merge letter
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Mulitple Listing of items within the single mail merge letter
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. -- Regards, OssieMac |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format Cell using letter & number to use in mail merge | Excel Worksheet Functions | |||
| Send a letter via e-mail merge to several people? | Excel Discussion (Misc queries) | |||
| Use Letter Template but not Mail Merge | Excel Discussion (Misc queries) | |||
| doing mail merge with excel the first letter in zip code is missi | Excel Discussion (Misc queries) | |||
| in mail merge can you add something in to the body of the letter | Excel Discussion (Misc queries) | |||
Hybrid Mode
