Forum » Programiranje » Outlook macro - dodaj/odstrani kontakt
Outlook macro - dodaj/odstrani kontakt
![](https://static.slo-tech.com/stili/avatar_gray.gif)
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 :)
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 :)
![](https://static.slo-tech.com/stili/bel_non_grata.png)
popster ::
http://blog.tjitjing.com/index.php/2007...
tle imaš nekaj podobnega, sicer pa mislim da bo to kar nekaj dela..
tle imaš nekaj podobnega, sicer pa mislim da bo to kar nekaj dela..
Vredno ogleda ...
Tema | Ogledi | Zadnje sporočilo | |
---|---|---|---|
Tema | Ogledi | Zadnje sporočilo | |
» | Deli za vozilaOddelek: Kaj kupiti | 1648 (1342) | Polanc |
⊘ | SAMI SCAMMERJI. hahahaOddelek: Omrežja in internet | 1266 (1179) | Ziga Dolhar |
» | Nov članek: "All your firmware are belong to us" (strani: 1 2 3 )Oddelek: Novice / Nova vsebina | 16864 (13704) | arrigo |
» | Tožbe proti nigerijskim prevarantomOddelek: Novice / Tožbe | 3882 (3882) | DMouse |