Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Working with Embedded File Object

Posted on 2006-04-18
5
Medium Priority
?
235 Views
Last Modified: 2013-12-18
Hello -

I am creating a front end to a fax system.  I have to give the users the ability to add cover sheets to their outbound faxes.  When a fax is sent, I need to be able to use an embedded file object (Word Docs with defined merge fields) that I have saved in the database as templates.  With it, I need to fill in the necessary information programmatically such as the "To", "FaxNumber" and "Comments" fields and save it as a temporary document to be sent out with the fax.  Each fax and cover sheet will be processed individually so there is no need to store tables of information.

I need to know how to make a copy of the stored word doc and how to access and populate the doc fields once I access it.


Thanks!
0
Comment
Question by:KDrago
  • 3
  • 2
5 Comments
 
LVL 14

Expert Comment

by:cezarF
ID: 16484037
since you posted your question here, i assume that you are using domino designer to develop the front end. i would suggest using subforms as your templates instead of word documents. it will allow you to easily populate the fax cover sheet with the information you want.
0
 

Author Comment

by:KDrago
ID: 16487275
Yes using domino designer as the front end - guess I should have stated that.  

I am using Word documents so the users can add and maintain their cover sheets as opposed to having to having to do a programming change every time someone needs a new one.  They are familiar with mail merges so developing cover sheets in this way seemed the best way to keep the maintenance in their hands.  

We are a company that has many subdivisions so the there are many different custom cover sheets they will want to create and maintain.
0
 
LVL 14

Accepted Solution

by:
cezarF earned 2000 total points
ID: 16493982
I see.  this is what i think you need.

1. If your word templates are attached to a notes document, you have to extract them to the local pc
2. create a word document OLE automation based on the template (.dot), fill in the necessary information and save it (.doc)
3. create a lotus notes fax document
4. embed the saved word document as an object (EMBED_OBJECT) in a NotesRichtextItem and save/send the document.

hope it helps




0
 

Author Comment

by:KDrago
ID: 16525820
Thanks cezarF.  I modeled something based on your suggestion and it is working out well.  
0
 
LVL 14

Expert Comment

by:cezarF
ID: 16530689
glad it worked. thanks for the points. :)
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For beginners of Lotus Notes user this is important to know about the types of files and their location supported by IBM Notes. Mostly users are unaware about how many file types are created and what their usages are. This Article is fully dedicated…
Article by: Rob
Notes 8.5 Archiving Steps and Tips This article covers setting up a Notes archive, and helps understand some of the menu choices making setting up and maintaining a Notes archive file easier.
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question