Shell only outputting first two lines

[Sandman83]

Hi All;

I am trying to use Access to to get the IP Address of multiple PC's via NSLookup. I am using the following code to output the information to a txt file;

When ever I run this code from an Access module I only get the first two lines of output.

dblRetVal = Shell("cmd /c nslookup.exe [i]hostname[/i] > C:\NSLOOKUPDATA.TXT", vbHide)

Server: servername.work.com
Address: 10.55.224.100

If I copy and paste

cmd /c nslookup.exe [i]hostname[/i] > C:\NSLOOKUPDATA.TXT

into a command prompt I get all five (If you count the blank line as the third line) expected lines of output.

Server: servername.work.com
Address: 10.55.224.100

Name: pcname.work.com
Address: 10.11.89.115

Any ideas why this would be happening?

Thanks in advance,

Tim