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.

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.

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.