Auto send messages issue

**facuse** · 01-13-2010, 11:07 PM

I am trying to run a macro on Outlook to send a lot of messages to different parties. The macro does work but the information that I am sending for each of them is unique so each of them should get different data but some how when I run the macro, data will mixed amount parties. Lets say that party 1 should get data 1 and party 2 should get data 2 and this is not happening, party 1 is getting data 2 and party 2 is getting data 1 or someone else data but not the one that belongs to it.

'macro

Please Login or Register  to view this content.

Can anyone help me please?

MOD: please use CODE tags rather than QUOTE tags going forward... modified on this occasion for you.

**DonkeyOte** · 01-14-2010, 03:44 AM

Maybe I'm missing something but there's nothing that I can see in your code that determines the actual content of each mail item .... and it is seemingly the content that is your concern, no ?

**facuse** · 01-14-2010, 09:09 AM

I am running an access data base with another macro to uploaded all emails to draft folder, then once I have all emails in draft forder I run this macro and there is when data gets mix.

**DonkeyOte** · 01-14-2010, 09:39 AM

I'm afraid you've lost me... all your code is doing is iterating the mail items in your Draft folder and mailing them if there's an address stipulated in the To field... what is actually in the email itself has nothing to do with the code you have posted.

Perhaps someone else can help as I'm drawing a blank I'm afraid.

**darbid** · 01-20-2010, 03:09 AM

facuse currently the code you have posted is the code in Outlook. This code only checks if there is a TO in the choosen folder and then sends it.

Getting out my crystal ball what you are doing here is generating emails in Access. and putting them all in one folder.
Then to avoid Microsofts inability to do get things right (Unavoidable Security Messages) you are sending them from outlook.

The data1 and party 2 choice is not in the code you have posted it is in the Access code that generates these emails.

If you are still having problems you need to post that code.