Hey Paul, I am using Microsoft Outlook. The source for the e-mail is an Excel worksheet (not standard) from the people I receive the figures from (35 in total). This e-mails I have to process further in an Excel worksheet.
With the logging I mean that within the spreadsheet and in Outlook (to cover figures with both input and crosscheck) the figures Regards, Anton On 16 apr, 17:19, Paul Schreiner <schreiner_p...@att.net> wrote: > There's all sorts of levels of automation for this. > What email program are you using? > What is the source of the content of the email? > > for instance... > If you run it all from the spreadsheet, > you could create a VBA application that CREATES the emails from data in the > spreadsheet. > That way, you already are logging the number in the spreadsheet. > As far as "mails are logged for tracking purposes". > How are they logged? within the email by keeping a copy? > or is that the manual entry you're referring to? > > Paul > > ________________________________ > From: Ometoon <omet...@hotmail.com> > To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> > Sent: Thursday, April 16, 2009 10:56:01 AM > Subject: $$Excel-Macros$$ automate steps with VB > > Hello, > > At work I am confrontated with the situation mentioned below: > > 1. From approx. 35 countries mails are sent with a figure (one number) > of the revenues on a weekly basis > 2. The mails are logged for tracking purposes > 3. From the mails a number in the message body is entered manually in > a spreadsheet > > The three steps above are done by me manually. What I would like to > know how I can use Visual Basic to (partially) automate the steps > above. > > Can someone please help me with this? > > Thanks a lot! > > Greets, > > Anton --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
