Excel XP Conditional Send Mail

[Adnane]

Hi,
i need to send a word document from an excel file based on a flag.

an extract of the xl file would be:

Customer Doc Mail_address Send

Customer1 My_Doc address1@server.com yes
Customer2 My_Doc1 address2@server.com No

what i would like to end up with is to send my_doc to only Customer1 since it has the flag "yes" and then replace the flag by "Sent"

Thanks

 

[Dreamboat]

First, you can change the Yes and No to Sent or not sent and use Y ONLY when it has been sent.

Then, you can use a mailmerge to send the file/message.

In the criteria of a mail merge query, you can put where field "Sent" is blank.

You'll have to then manually update the Excel file, but you can easily select the cells where the Yes would appear, and hit Edit-Go to-Special-Blanks, Ok. Once selected, type Y or Yes and hit Ctrl+Enter (or is that shift+enter?).

To automate it would take quite a bit of coding...

Anne Troy

http://www.TheOfficeExperts.com

Word and Excel Macros
Coming soon: wX

 

[Adnane]

Thanks Anne. The mail merge is a good solution but actually it has be something 100% automated. so that the user just runs the macro and that's it.

Adnane