I've got an air conditioning control box that is sending me these emails that have only numbers and spaces in. To understand this, I have to do text to columns (excel) then a few other formulas that finally give me the classic 0s and 1s. They are not fixed width, so I cant use right left and mid. I've linked outlook and access, as these emails go in to a special mailbox. Every half hour 10 of these emails come in....
Here is an example:
3 10 13 15 0 0 160 199 178 161 206 205 560 272 0 160 199 178 161 206 205 560 272 0 161 202 178 161 208 206 560 272 0 161 203 178 161 208 206 560 272 0 161 204 179 162 209 207 560 272 0 164 205 178 166 208 207 560 272 0 167 207 181 170 207 207 560 272 0 172 209 186 176 209 203 560 272 0 178 211 187 182 208 201 560 272 0 181 212 184 184 207 201 560 272 0 182 212 182 186 210 204 16 272 0 186 212 181 189 211 205 16 272 0 186 214 188 188 211 203 16 272 0 183 215 188 182 210 201 16 272 0 180 215 183 179 212 202 16 272 0 179 214 182 178 213 204 16 272 0 179 214 182 179 213 204 16 272 0 180 215 184 180 213 203 16 272 0 181 215 182 181 214 204 16 272 0 180 214 181 180 212 204 16 272 0 180 215 180 180 214 204 0 272 0 181 215 179 182 214 204 0 272 0 182 215 180 181 215 204 0 272 0 182 215 180 182 214 204 0 272 0 186 215 180 188 215 204 0 272 0 191 215 181 193 215 204 0 272 0 193 215 181 195 215 204 0 272 0 192 215 180 192 215 204 0 272 0 190 215 181 189 215 204 0 272 0 188 215 181 187 215 204 0 272 0 186 215 179 185 215 204 0 272 0 184 215 179 182 215 204 0 272 0 182 215 180 181 215 203 0 272 0 180 215 179 179 215 203 0 272 0 180 215 180 179 215 203 0 272 0 179 215 179 177 215 203 0 272 0
This is the only text in the body
Any ideas how I can do this? Thanks