| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
format a mail-merge file to send 1 message with a list of items
I need to fromat an Excel file that will send one mail message and list
several items. I have a list of employees and their managers. I want to send one message to the manager with a list of their employees. Example Input: Employee A1 Manager A1 Employee B1 Manager B1 Employee B2 Manager B1 Employee B3 Manager B1 Employee C1 Manager C1 Employee C2 Manager C1 Example Output: Employee A1 Manager A1 Employee B1 Employee B2 Employee B3 Manager B1 Employee C1 Employee C2 Manager C1 The way I found that works is to copy employee data for a manager from the input, paste to a Notepad file and copy from Notepad and paste to the FORMULA line in the output. Then copy one line of the manager data and paste to the output. I know there must be a better way!!! Any help is appreciated. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
format a mail-merge file to send 1 message with a list of items
I have code for Outlook but not for Notes
Maybe you can change it ?? See http://www.rondebruin.nl/mail/folder3/row2.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "mdl" wrote in message ... I need to fromat an Excel file that will send one mail message and list several items. I have a list of employees and their managers. I want to send one message to the manager with a list of their employees. Example Input: Employee A1 Manager A1 Employee B1 Manager B1 Employee B2 Manager B1 Employee B3 Manager B1 Employee C1 Manager C1 Employee C2 Manager C1 Example Output: Employee A1 Manager A1 Employee B1 Employee B2 Employee B3 Manager B1 Employee C1 Employee C2 Manager C1 The way I found that works is to copy employee data for a manager from the input, paste to a Notepad file and copy from Notepad and paste to the FORMULA line in the output. Then copy one line of the manager data and paste to the output. I know there must be a better way!!! Any help is appreciated. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
format a mail-merge file to send 1 message with a list of item
Ron,
Thanks for the info. I will let you know how if it works for me. "Ron de Bruin" wrote: I have code for Outlook but not for Notes Maybe you can change it ?? See http://www.rondebruin.nl/mail/folder3/row2.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "mdl" wrote in message ... I need to fromat an Excel file that will send one mail message and list several items. I have a list of employees and their managers. I want to send one message to the manager with a list of their employees. Example Input: Employee A1 Manager A1 Employee B1 Manager B1 Employee B2 Manager B1 Employee B3 Manager B1 Employee C1 Manager C1 Employee C2 Manager C1 Example Output: Employee A1 Manager A1 Employee B1 Employee B2 Employee B3 Manager B1 Employee C1 Employee C2 Manager C1 The way I found that works is to copy employee data for a manager from the input, paste to a Notepad file and copy from Notepad and paste to the FORMULA line in the output. Then copy one line of the manager data and paste to the output. I know there must be a better way!!! Any help is appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SEND MAIL TO DIFFERENT ADDRESS WITH DIFFERENT MESSAGE | Excel Programming | |||
| Send a letter via e-mail merge to several people? | Excel Discussion (Misc queries) | |||
| Excel mailing list in wrong format for mail merge | Excel Discussion (Misc queries) | |||
| How do i suppress the message when trying to send mail from xcel | Excel Discussion (Misc queries) | |||
| Send Mail Merge Auto-Emails based on date | Excel Programming | |||
Linear Mode
