Hi,
I have two different custom forms in Outlook contacts. I need to fill out automaticly data from these two types of forms into document template (word/excel/body of email/doesn't metter).
If I had to fill my template with data from only one form, there was no problem, I used merge mail. But I have no idea how to do this with data from two forms. :?

Please, does somebody have idea, how can I do this? Is it possible with macro/VBScript or not?
Thanks in advance,
Jana
--
Have a nice day

It's not clear just what you're trying to do. Forms are UI/code templates. They contain no data themselves.

Are you saying that you want to use the data from two different items to fill a template-based document? What relationship do those two items have?

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Luki" wrote in message ...
Hi,
I have two different custom forms in Outlook contacts. I need to fill out automaticly data from these two types of forms into document template (word/excel/body of email/doesn't metter).
If I had to fill my template with data from only one form, there was no problem, I used merge mail. But I have no idea how to do this with data from two forms. :?

Please, does somebody have idea, how can I do this? Is it possible with macro/VBScript or not?
Thanks in advance,
Jana
--
Have a nice day

In article , Luki wrote:
If I had to fill my template with data from only one form, there was no problem, I used merge mail. But I have no idea how to do this with data from two forms. :?

If we are talking about just two source forms, then you can manually past each form's data into
Excel and then use Excel as the mail merge source.

--
Hollis Paul
Mukilteo, WA USA

Hi Sue,
I am sorry..

Are you saying that you want to use the data from two different items to fill a template-based document? ..yes

My example:
I have all data in two types(two different items)of contacts ..Schools and Pupils. ..so I have there two different custom forms. Relation: in Pupil contact is the name of his school(s). I need to use data from Pupil and School Items to fill into one document template (the best would be automatically).
E.g. in Word's document template using mail merge u can define the fields, which are replaced by/filled with data from the contact (e.g. pupil) automatically. And I would like to fill there data from pupils and schools(two different Outlook contacts forms).

I think, that I'll have to write code in VBS, or not? Thanks a lot for some better or easier solution..
--
Have a nice day

Yes, you will need to write code to do this. If you want the code to run as part of an Outlook form, it will be VBSCript.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Luki" wrote in message ...
Hi Sue,
I am sorry..

Are you saying that you want to use the data from two different items to fill a template-based document? ..yes

My example:
I have all data in two types(two different items)of contacts ..Schools and Pupils. ..so I have there two different custom forms. Relation: in Pupil contact is the name of his school(s). I need to use data from Pupil and School Items to fill into one document template (the best would be automatically).
E.g. in Word's document template using mail merge u can define the fields, which are replaced by/filled with data from the contact (e.g. pupil) automatically. And I would like to fill there data from pupils and schools(two different Outlook contacts forms).

I think, that I'll have to write code in VBS, or not? Thanks a lot for some better or easier solution..
--
Have a nice day