Raghu Prabhu
New Member
Hello Chandoo,
I was doing this in MS Access. Everything was working beautifully. For some reason beyond my control, my company has got rid of MS Access when we had the hardware upgraded and we have been instructed to use only MS excel.
I have to create and email pay instructions to 60 offices around the world.
There are a couple of questions in this thread…
1. Prevent the previously imported file to be imported again. See the “PayDays” tab in the worksheet. If the “Imported” column is “Yes” then next one has to be imported. If the file is imported, then the column has to be updated to "Yes"
2. The pay advises have to be created in txt files. UK office wants it formatted differently
3. Email the pay advises to the correct offices.
The pay instructions have to be prepared as shown in the attached files.
All countries including want the instructions in one format, while UK wants in unique format.
The naming format is “Country – payday.txt”
Once the pay instructions files are created, must be attached to the email and sent to the correct office. The subject line should have “Country – payday”
Thank you
Regards
Raghu
I was doing this in MS Access. Everything was working beautifully. For some reason beyond my control, my company has got rid of MS Access when we had the hardware upgraded and we have been instructed to use only MS excel.
I have to create and email pay instructions to 60 offices around the world.
There are a couple of questions in this thread…
1. Prevent the previously imported file to be imported again. See the “PayDays” tab in the worksheet. If the “Imported” column is “Yes” then next one has to be imported. If the file is imported, then the column has to be updated to "Yes"
2. The pay advises have to be created in txt files. UK office wants it formatted differently
3. Email the pay advises to the correct offices.
The pay instructions have to be prepared as shown in the attached files.
All countries including want the instructions in one format, while UK wants in unique format.
The naming format is “Country – payday.txt”
Once the pay instructions files are created, must be attached to the email and sent to the correct office. The subject line should have “Country – payday”
Thank you
Regards
Raghu