» »

Outlook macro - dodaj/odstrani kontakt

Outlook macro - dodaj/odstrani kontakt

triscom5 ::

Hello good people! :)

I need help from an expert in (outlook) macros writing. What I would like to do is,
exstract some data from a email body and store it into Outlook contacts. See the picture
with proccess flow. All received emails have a standard form for newsletter subscription
and it would look like this:


Email*: tony.stark@stark-industries.com

Name: Tony Stark

Company: Stark Industries

Action*: Subscribe




So I need a macro that would check the text after "Action*: ", if it is Subscribe or Unsubscribe.

1. If it is Subscribe:

- check if there is already a contact with this email address in Outlook Contacts
> if it is, write message: "Subscriber already exists."
> go to END

- else, generate new contact and copy data from email body to it
> the text after "Name: " goes into Name field
> the text after "Email: " goes into Email field
> the text after "Company: " goes into Company field
> write message: New subscriber %Name% added.
> go to END



2. If it is Unsubscribe:
- check if there is already a contact with this email address in Outlook Contacts
> if it is not, write message: "Subscriber does not exist!"
> go to END
- else, delete the contact
> write message: Subscriber %Name% deleted.
> go to END

IMAGE: PROCCES FLOW

Thank you guys for your help!!!

p.s. besedilo sem napisal v angleščini, da v kolikor je tudi kak tuj strokovnjak tule gor. odgovor pa je lahko tudi slovenski :)

popster ::

http://blog.tjitjing.com/index.php/2007...
tle imaš nekaj podobnega, sicer pa mislim da bo to kar nekaj dela..


Vredno ogleda ...

TemaSporočilaOglediZadnje sporočilo
TemaSporočilaOglediZadnje sporočilo
»

Deli za vozila

Oddelek: Kaj kupiti
91648 (1342) Polanc

SAMI SCAMMERJI. hahaha

Oddelek: Omrežja in internet
121266 (1179) Ziga Dolhar
»

Nov članek: "All your firmware are belong to us" (strani: 1 2 3 )

Oddelek: Novice / Nova vsebina
13816864 (13704) arrigo
»

Tožbe proti nigerijskim prevarantom

Oddelek: Novice / Tožbe
153882 (3882) DMouse

Več podobnih tem