Hi all,

I have a scenario in which we have individual salary related files for around 400 employess and we want to send them their respective file. If we send them one by one then chances of mistakes are very high.
Is there any way that we store outlook addresses and file path some where and outlook pick the address and corresponding file from file path and create and send individual messages. .
Submitted using http://www.outlookforums.com

There are lots of ways you can write code to do something like this, but you
don't provide nearly enough information to even suggest something.

Where are those salary files stored and in what format? Are they Excel
files, Word files, in a database or what? How are they named, related to the
names of the employees? Are the employees all in a Global Address List in
Exchange Server? If not where is a list of all employees stored along with
their email addresses?

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"Muhammad asif" masif74[at]hotmail[dot]com wrote in message
...
Hi all,

I have a scenario in which we have individual salary related files for
around 400 employess and we want to send them their respective file. If we
send them one by one then chances of mistakes are very high. Is there any
way that we store outlook addresses and file path some where and outlook
pick the address and corresponding file from file path and create and send
individual messages. . Submitted using http://www.outlookforums.com

Hi,

Here is some details:

1- The salary files will be stored on C drive of the system
2- These salary file are text files normaly open with notepad
3- Salary file name will start with employee code assigned in payroll system
4- All employees are in global address list in Exchange server

Muhammad Asif

kenslovak wrote on Tue, 01 September 2009 09:12
There are lots of ways you can write code to do something like this, but you
don't provide nearly enough information to even suggest something.

Where are those salary files stored and in what format? Are they Excel
files, Word files, in a database or what? How are they named, related to the
names of the employees? Are the employees all in a Global Address List in
Exchange Server? If not where is a list of all employees stored along with
their email addresses?

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"Muhammad asif" masif74[at]hotmail[dot]com wrote in message
...
Hi all,

I have a scenario in which we have individual salary related files for
around 400 employess and we want to send them their respective file. If we
send them one by one then chances of mistakes are very high. Is there any
way that we store outlook addresses and file path some where and outlook
pick the address and corresponding file from file path and create and send
individual messages. . Submitted using http://www.outlookforums.com

You obviously need some way of correlating between those employee codes and
the employees in the GAL. Either your admins need to add the employee codes
to a field in each AddressEntry in the GAL so you can look them up and match
them to the file names in the file system, or you need to be able to query
your payroll system to correlate the file names to employees.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"Muhammad asif" masif74[at]hotmail[dot]com wrote in message
...
Hi,

Here is some details:

1- The salary files will be stored on C drive of the system
2- These salary file are text files normaly open with notepad
3- Salary file name will start with employee code assigned in payroll
system
4- All employees are in global address list in Exchange server

actually I am new in Outlook programming. Can you give idea how I will do this outlook. I mean which option I should use to implement this solution. .
Submitted using http://www.outlookforums.com

You haven't provided enough information. It's impossible to say to how to do
what you want without knowing all about your infrastructure.

I have no idea how you'd access your payroll system, I don't know how the
employee codes are stored or where or how that would be correlated with
whatever is in the GAL.

You really need to hire an analyst or architect to study your
infrastructure, see what needs to be implemented and at least outline a
methodology.

That's not something you're going to get in a newsgroup when you aren't even
providing enough information for any analysis.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"Muhammad asif" masif74[at]hotmail[dot]com wrote in message
...
actually I am new in Outlook programming. Can you give idea how I will do
this outlook. I mean which option I should use to implement this solution.
. Submitted using http://www.outlookforums.com