Outlook 2007

[Muhammad asif]

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

 

[Ken Slovak - [MVP - Outlook]]

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?

 

[Muhammad asif]

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:1

 

[Ken Slovak - [MVP - Outlook]]

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.

 

[Muhammad asif]

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

 

[Ken Slovak - [MVP - Outlook]]

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.