PDA

View Full Version : Collect data and send mail



Cass
09-30-2005, 05:34 AM
Hi!

How to resolve this project:
Destination is loop rows where is quantity and collect information and send email with this data.
If project is complete then i must send workbook copy every client.
Now biggest problem is; different Windows (maybe not) and Office versions. For the most part different Office versions i think.

Where to start VBA?
1) check OS version?
2) check Office version?
two different ways send email. 1) open Outlook or Outlook Express New mail with excel data OR 2) send email directly into Excel http://vbaexpress.com/forum/images/smilies/102.gif

Settings on first open?!
Set OS and Office version and save file. Second opening is this info already done and evermore not us this part of code.

Is my idea to do this very stupid?!

lucas
10-01-2005, 11:38 AM
Hi Cass,
No, this is not a stupid question. There are lots of kb entries dealing with this subject. I started to link one or two knowledgebase entries to this post so you could check them out but there are so many that I will just link the search engine for the knowledgebase. After you click on the link, select Excel as the application and use email for the search term. I'm sure you will find something there that will help you. If not, post back here for additional help or help with one of the entries.

http://vbaexpress.com/kb/default.php?action=search

ps. I don't think you need to be overly concerned about os or version. You may have to make a trial run or two.