A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Looping thru Inbox



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old March 11th 08, 08:20 PM posted to microsoft.public.outlook.program_vba
RS
external usenet poster
 
Posts: 28
Default Looping thru Inbox

I gather data from incoming emails. Sometimes, two emails can be referencing
the same request and I can tell that by the subject line. Is it possible to
pick up data from both emails into one record while going thru the mailbox.

eg. Email 1 has Name
Email 2 has the address
both of them have same subject line.
I want my record to show name and address.
Email 3 can have name and address in it.

How do I construct the loop so it checks if 2 email have same subject line
then pick data up from both emails.

Thanks Much.
Ads
  #2  
Old March 12th 08, 05:41 AM posted to microsoft.public.outlook.program_vba
Michael Bauer [MVP - Outlook]
external usenet poster
 
Posts: 1,885
Default Looping thru Inbox



Before the loop, sort the Items collection by subject. Then in every cycle
of the loop (except the last one) check if the next item after has the same
subject as the current item.

--
Best regards
Michael Bauer - MVP Outlook
Use Outlook Categories? This is Your Tool:
http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6

Am Tue, 11 Mar 2008 13:20:32 -0700 schrieb RS:

I gather data from incoming emails. Sometimes, two emails can be

referencing
the same request and I can tell that by the subject line. Is it possible

to
pick up data from both emails into one record while going thru the

mailbox.

eg. Email 1 has Name
Email 2 has the address
both of them have same subject line.
I want my record to show name and address.
Email 3 can have name and address in it.

How do I construct the loop so it checks if 2 email have same subject line
then pick data up from both emails.

Thanks Much.

 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Looping through and/or creating Exchange folders via Redemption Mike Add-ins for Outlook 7 October 12th 07 07:28 PM
Looping Through and Exporting Outlook 2003 Messages Gwhit Outlook and VBA 1 October 13th 06 07:02 AM
Problem Looping Through Contacts Andibevan Outlook and VBA 4 September 13th 06 10:14 AM
Problems looping through Recipients in a draft message saeongjeema via OfficeKB.com Outlook and VBA 1 February 27th 06 06:12 AM
Calendar looping through the current month? Sydney Outlook and VBA 2 February 8th 06 01:21 PM


All times are GMT +1. The time now is 03:39 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.