Conditional Emailing

[wmtsub]

I have a spreadsheet with past due dates for my clients. I have broken them down into 5 categories displayed in one column. 0 = on time , 1= 1-5 days late, 2= 5-10 days late,3= days late, 4= excess of 14 days late. I would like to rum a macro weekly and email a letter to each vendor. I have a column with the emails as well, what I would like is if the email tag Colum =0 then nothing, if it -1 send a specific verbiage, if it =2 a different verbiage, etc.

Any help would be appreciated.

 

[Brombrough]

Hi wmtsub,

What you are asking is too much for one post I think you need to break it down in steps. Get pass one step, then move onto the next step. I don't think there is a quick fix.

Possible steps are.

UDF 1. Create a wording (HTML (This is what outlook uses) or other languages) as to the content of your email different verbiages. Include any logo's etc (Do you want it as an attachment (Word Doc or HTML as an email formated).
UDF 2. Get standard wording from user's signature into your email.
UDF 3. Remember you need individual emails. You don't want clients knowing other clients business.
UDF 4. Now put all your UDF's together and send them. (Tip save emails first to drafts folder, don't just send them to make sure you get it right first)

Putting all this together might take some time your you could ask someone to do it for you.

Sorry, not good news but hope it helps in your quest.