How to merge data from two outlook forms?
 

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 :)

How to merge data from two outlook forms?
 

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 :)

How to merge data from two outlook forms?
 

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

How to merge data from two outlook forms?
 

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 :)

How to merge data from two outlook forms?
 

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 :)