Tech Support Guy banner
Status
Not open for further replies.
1 - 8 of 8 Posts

·
Registered
Joined
·
5 Posts
Discussion Starter · #1 ·
I import information into Excel every morning that looks something like the attachment. What I need to do is have a macro that takes the information and groups it by Transport Officer and mails it to the relevant contact with the following wording in the body of an email - or attachment - if that is easier.

Afternoon "Insert the first name of the transport officer"

Could you please confirm if the following vehicle is standing / on the road :

List of all the relevant registration numbers

Many Thanks

I hope this makes sense and that someone can help.

Thanks :confused:
 

Attachments

·
Trusted Advisor
Joined
·
6,911 Posts
I haven't looked at the Excel sheet yet, but does it have to be Excel?
I have something similar in good old MS-Dos and vbs that runs perfectly (also under Windows 7)
 

·
Trusted Advisor
Joined
·
6,911 Posts
Hi,
Got it, will try som things and let you kow
 

·
Registered
Joined
·
7,837 Posts
mandarin, I just looked at your Excel spreadsheet and it looks like it is real data. Perhaps it isn't confidential (although I would assume it is work-related) but it certainly is full of emails, which appear to be valid. One should never post data which is real. Please read this post before you upload again.
http://forums.techguy.org/business-applications/689922-do-not-post-attach-private.html

Please, delete the file and upload one with fake data. If you can't remove it, let us know and a moderator can remove it.
 
1 - 8 of 8 Posts
Status
Not open for further replies.
Top