I get an e-mail from our web site every day and the data contained inside
it is data that I end up entering into a form via cut and past item by
item and I want to automate this.
I have included the pertinent info below inbetween the data start and end
lines (that I added for inclusion here), there are other e-mail headers
and footers the the web page adds, but this is what I only need.
Any ideas how to automate this? I thought there might be a way to just
copy it all to the clipboard then have some function retreive it from
there and then do some sort of recordset add new procedure. But I don't
know how to deal with the structued text nor do I know how to get it from
the clipboard (maybe just saving it to a file and having Access read it
from a file, but that is new to me as well.)
Thanks.
********DATA START****************
Product Demo AutoRequest 1.0
Name=John Doe
Title=Network Admin
Company=Aaccmee Industries
StreetAddress=12345 Main Ave
StreetAddress2
City=Indpls
State=IN
ZipCode=46203
Country=US
Phone=317-555-1212
Email=johnd@a...
********DATA START****************