Third party attach .txt file

A

AMT

Hello Everyone,
I have a third party email notification
program that attaches a .txt file that draws information
from different rows on SQL database located on the same
Server (see attached file for coding. How can I edit this
file in order to change where the .txt file is pointing
to. e.g (if i wanted to add Duration: [duration time]
pointing to the value in the SQL dbase.

thank you in advance
AMT

Confirm1aa.txt
------------------------------------------

Reference No : [RNUM]
Date : [DATE]
Time : [TIME]
Company : [CMNAME]
Email Address : [EMAILADR]
Attention : [NAME]

------------------------------------------

Conference Confirmation

Your conference booking has been confirmed for [LOCALDATE]
at [LOCALTIME].

Your conference call is booked as follows:

* Conference name: [CNAME]
* Scheduled Conf Date: [LOCALDATE]
* Scheduled Conf Time: [LOCALTIME] [TZONE]
* Conference Reference: [CNUM]
* Number of participants: [CFREES]
* Dial-in Number: [DDI]
* Moderator Pin access code: [MPIN]
* Participant Pin access code: [CPIN]

------------------------------------------

Here are the calling instructions for your DIAL-IN
conference.

1. Dial [DDI] and follow the voice prompts.
2. At the voice prompt, press the Conference Code [PIN]
and the # key.
3. You will be connected to the conference if your
Conference Code is correct. Otherwise, you will be
transferred to a conference operator for assistance.
4. Press * and 0 for the assistance of a conference
operator during the conference.
5. If you are disconnected for any reason, you can dial
[DDI] and Conference Code [PIN]

------------------------------------------

Contact: [CHAIRNAME] MAILTO:[CHAIREMAIL]

[SYSOWN1]
[SYSADR1]
[SYSADR2]

[FTEXT]
 
S

Sue Mosher [MVP-Outlook]

Try posting in a SQL group; this doesn't seem to be related to Outlook.
Seems to me that you'd need to know the field name for the duration field in
the SQL table.
 
A

AMT

ok thanks..i'll try that
-----Original Message-----
Try posting in a SQL group; this doesn't seem to be related to Outlook.
Seems to me that you'd need to know the field name for the duration field in
the SQL table.
--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers



Hello Everyone,
I have a third party email notification
program that attaches a .txt file that draws information
from different rows on SQL database located on the same
Server (see attached file for coding. How can I edit this
file in order to change where the .txt file is pointing
to. e.g (if i wanted to add Duration: [duration time]
pointing to the value in the SQL dbase.

thank you in advance
AMT

Confirm1aa.txt
------------------------------------------

Reference No : [RNUM]
Date : [DATE]
Time : [TIME]
Company : [CMNAME]
Email Address : [EMAILADR]
Attention : [NAME]

------------------------------------------

Conference Confirmation

Your conference booking has been confirmed for [LOCALDATE]
at [LOCALTIME].

Your conference call is booked as follows:

* Conference name: [CNAME]
* Scheduled Conf Date: [LOCALDATE]
* Scheduled Conf Time: [LOCALTIME] [TZONE]
* Conference Reference: [CNUM]
* Number of participants: [CFREES]
* Dial-in Number: [DDI]
* Moderator Pin access code: [MPIN]
* Participant Pin access code: [CPIN]

------------------------------------------

Here are the calling instructions for your DIAL-IN
conference.

1. Dial [DDI] and follow the voice prompts.
2. At the voice prompt, press the Conference Code [PIN]
and the # key.
3. You will be connected to the conference if your
Conference Code is correct. Otherwise, you will be
transferred to a conference operator for assistance.
4. Press * and 0 for the assistance of a conference
operator during the conference.
5. If you are disconnected for any reason, you can dial
[DDI] and Conference Code [PIN]

------------------------------------------

Contact: [CHAIRNAME] MAILTO:[CHAIREMAIL]

[SYSOWN1]
[SYSADR1]
[SYSADR2]

[FTEXT]
Click to expand...


.
Click to expand...
 
Top