I run a small home run I.T. Support company any have developed an Access 2007
database for all our business activities. I currently send email using a VBA
script although it does not allow me to be as flexible as I would like.

I often send emails to customers where I would like to have a good looking
email, as I have created an outlook template (oft) with our logo and the
formatting just as I want it.

An example of our requirement is to be able to add a time and date value
from an access form into one of these templates, along with initially opening
the template, then adding the email address again from a record value in the
access form.

My idea was to do it in a similar way to how we achieve sending data to a
Word 2007 template - by using bookmarks. This would allow us to preformat the
standard emails in a oft template file and then simply drop the required data
from the Access form into it at the bookmark locations.
Do you know where I can go with this, as I've spent hours crawling the
forums and have hit a wall!!

Look forward to your reply.

An Outlook .oft file doesn't have bookmarks. You have two choices he

1) Use a Word document as the starting point, and use the code technique
shown at http://www.outlookcode.com/codedetail.aspx?id=1333 to generate the
email messages.

-or-

2) Use placeholder text in your .oft file to mark the locations where you
want to replace that placeholder text with, for example, the date and time.

#2 is easier. Just call the Replace() function on the item's HTMLBody
property as needed.

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


"Simon Hughes (ICSNET UK)" Simon Hughes (ICSNET
wrote in message
...
I run a small home run I.T. Support company any have developed an Access
2007
database for all our business activities. I currently send email using a
VBA
script although it does not allow me to be as flexible as I would like.

I often send emails to customers where I would like to have a good looking
email, as I have created an outlook template (oft) with our logo and the
formatting just as I want it.

An example of our requirement is to be able to add a time and date value
from an access form into one of these templates, along with initially
opening
the template, then adding the email address again from a record value in
the
access form.

My idea was to do it in a similar way to how we achieve sending data to a
Word 2007 template - by using bookmarks. This would allow us to preformat
the
standard emails in a oft template file and then simply drop the required
data
from the Access form into it at the bookmark locations.
Do you know where I can go with this, as I've spent hours crawling the
forums and have hit a wall!!

Look forward to your reply.

Hi Sue,

Thanks for your reply, very helpful.

However, I am quite new to VBA and I am a little unsure of how to code the
Replace() function and how to call the oft templete to open and inset the
email address.

I ok with calling a new email message and sending the to,cc,bbc, subject and
body and even HTMLBody although not sure of the replace function.

Could you help at all, maybe you have an example that you have worked with
previously to point me in the right direction?

Thanks in advance.

Simon



"Sue Mosher [MVP]" wrote:

An Outlook .oft file doesn't have bookmarks. You have two choices he

1) Use a Word document as the starting point, and use the code technique
shown at http://www.outlookcode.com/codedetail.aspx?id=1333 to generate the
email messages.

-or-

2) Use placeholder text in your .oft file to mark the locations where you
want to replace that placeholder text with, for example, the date and time.

#2 is easier. Just call the Replace() function on the item's HTMLBody
property as needed.

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


"Simon Hughes (ICSNET UK)" Simon Hughes (ICSNET
wrote in message
...
I run a small home run I.T. Support company any have developed an Access
2007
database for all our business activities. I currently send email using a
VBA
script although it does not allow me to be as flexible as I would like.

I often send emails to customers where I would like to have a good looking
email, as I have created an outlook template (oft) with our logo and the
formatting just as I want it.

An example of our requirement is to be able to add a time and date value
from an access form into one of these templates, along with initially
opening
the template, then adding the email address again from a record value in
the
access form.

My idea was to do it in a similar way to how we achieve sending data to a
Word 2007 template - by using bookmarks. This would allow us to preformat
the
standard emails in a oft template file and then simply drop the required
data
from the Access form into it at the bookmark locations.
Do you know where I can go with this, as I've spent hours crawling the
forums and have hit a wall!!

Look forward to your reply.


.

To create a new message from an .oft file, use the Outlook object model's
Application.CreateItemFromTemplate() method, passing the path to the .oft
file as the argument.

Replace() works the same no matter what text you use it on:

updatedText = Replace(originalText, findText, replaceText)

If you have problems making that work with your variables, post your
existing code.

There's a detailed example in my book, which is available on Google Books.
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Simon Hughes (ICSNET UK)"
wrote in message ...
Hi Sue,

Thanks for your reply, very helpful.

However, I am quite new to VBA and I am a little unsure of how to code the
Replace() function and how to call the oft templete to open and inset the
email address.

I ok with calling a new email message and sending the to,cc,bbc, subject
and
body and even HTMLBody although not sure of the replace function.

"Sue Mosher [MVP]" wrote:

An Outlook .oft file doesn't have bookmarks. You have two choices he

1) Use a Word document as the starting point, and use the code technique
shown at http://www.outlookcode.com/codedetail.aspx?id=1333 to generate
the
email messages.

-or-

2) Use placeholder text in your .oft file to mark the locations where you
want to replace that placeholder text with, for example, the date and
time.

#2 is easier. Just call the Replace() function on the item's HTMLBody
property as needed.

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


"Simon Hughes (ICSNET UK)" Simon Hughes (ICSNET
wrote in message
...
I run a small home run I.T. Support company any have developed an Access
2007
database for all our business activities. I currently send email using
a
VBA
script although it does not allow me to be as flexible as I would like.

I often send emails to customers where I would like to have a good
looking
email, as I have created an outlook template (oft) with our logo and
the
formatting just as I want it.

An example of our requirement is to be able to add a time and date
value
from an access form into one of these templates, along with initially
opening
the template, then adding the email address again from a record value
in
the
access form.

My idea was to do it in a similar way to how we achieve sending data to
a
Word 2007 template - by using bookmarks. This would allow us to
preformat
the
standard emails in a oft template file and then simply drop the
required
data
from the Access form into it at the bookmark locations.
Do you know where I can go with this, as I've spent hours crawling the
forums and have hit a wall!!

Look forward to your reply.


.

Hi Sue,

I appreciate your reply. I have just bought your book from Amazon am I am
expecting deliver on Thursday. Hopefully I can learn a thing or two from it !!

Which part of the book contains the sample code relating to my query?

Simon

"Sue Mosher [MVP]" wrote:

To create a new message from an .oft file, use the Outlook object model's
Application.CreateItemFromTemplate() method, passing the path to the .oft
file as the argument.

Replace() works the same no matter what text you use it on:

updatedText = Replace(originalText, findText, replaceText)

If you have problems making that work with your variables, post your
existing code.

There's a detailed example in my book, which is available on Google Books.
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Simon Hughes (ICSNET UK)"
wrote in message ...
Hi Sue,

Thanks for your reply, very helpful.

However, I am quite new to VBA and I am a little unsure of how to code the
Replace() function and how to call the oft templete to open and inset the
email address.

I ok with calling a new email message and sending the to,cc,bbc, subject
and
body and even HTMLBody although not sure of the replace function.

"Sue Mosher [MVP]" wrote:

An Outlook .oft file doesn't have bookmarks. You have two choices he

1) Use a Word document as the starting point, and use the code technique
shown at http://www.outlookcode.com/codedetail.aspx?id=1333 to generate
the
email messages.

-or-

2) Use placeholder text in your .oft file to mark the locations where you
want to replace that placeholder text with, for example, the date and
time.

#2 is easier. Just call the Replace() function on the item's HTMLBody
property as needed.

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


"Simon Hughes (ICSNET UK)" Simon Hughes (ICSNET
wrote in message
...
I run a small home run I.T. Support company any have developed an Access
2007
database for all our business activities. I currently send email using
a
VBA
script although it does not allow me to be as flexible as I would like.

I often send emails to customers where I would like to have a good
looking
email, as I have created an outlook template (oft) with our logo and
the
formatting just as I want it.

An example of our requirement is to be able to add a time and date
value
from an access form into one of these templates, along with initially
opening
the template, then adding the email address again from a record value
in
the
access form.

My idea was to do it in a similar way to how we achieve sending data to
a
Word 2007 template - by using bookmarks. This would allow us to
preformat
the
standard emails in a oft template file and then simply drop the
required
data
from the Access form into it at the bookmark locations.
Do you know where I can go with this, as I've spent hours crawling the
forums and have hit a wall!!

Look forward to your reply.


.



.

17.4.2 - Creating a message from a boilerplate template

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


"Simon Hughes (ICSNET UK)"
wrote in message ...
Hi Sue,

I appreciate your reply. I have just bought your book from Amazon am I am
expecting deliver on Thursday. Hopefully I can learn a thing or two from
it !!

Which part of the book contains the sample code relating to my query?

Simon

"Sue Mosher [MVP]" wrote:

To create a new message from an .oft file, use the Outlook object model's
Application.CreateItemFromTemplate() method, passing the path to the .oft
file as the argument.

Replace() works the same no matter what text you use it on:

updatedText = Replace(originalText, findText, replaceText)

If you have problems making that work with your variables, post your
existing code.

There's a detailed example in my book, which is available on Google
Books.

"Simon Hughes (ICSNET UK)"

wrote in message
...
Hi Sue,

Thanks for your reply, very helpful.

However, I am quite new to VBA and I am a little unsure of how to code
the
Replace() function and how to call the oft templete to open and inset
the
email address.

I ok with calling a new email message and sending the to,cc,bbc,
subject
and
body and even HTMLBody although not sure of the replace function.

"Sue Mosher [MVP]" wrote:

An Outlook .oft file doesn't have bookmarks. You have two choices
he

1) Use a Word document as the starting point, and use the code
technique
shown at http://www.outlookcode.com/codedetail.aspx?id=1333 to
generate
the
email messages.

-or-

2) Use placeholder text in your .oft file to mark the locations where
you
want to replace that placeholder text with, for example, the date and
time.

#2 is easier. Just call the Replace() function on the item's HTMLBody
property as needed.

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


"Simon Hughes (ICSNET UK)" Simon Hughes (ICSNET
wrote in message
...
I run a small home run I.T. Support company any have developed an
Access
2007
database for all our business activities. I currently send email
using
a
VBA
script although it does not allow me to be as flexible as I would
like.

I often send emails to customers where I would like to have a good
looking
email, as I have created an outlook template (oft) with our logo and
the
formatting just as I want it.

An example of our requirement is to be able to add a time and date
value
from an access form into one of these templates, along with
initially
opening
the template, then adding the email address again from a record
value
in
the
access form.

My idea was to do it in a similar way to how we achieve sending data
to
a
Word 2007 template - by using bookmarks. This would allow us to
preformat
the
standard emails in a oft template file and then simply drop the
required
data
from the Access form into it at the bookmark locations.
Do you know where I can go with this, as I've spent hours crawling
the
forums and have hit a wall!!

Look forward to your reply.


.



.

Hi Sue,

I have been reading through your book although I seem unable to grasp the
idea of writing the VBA for opening a oft file and utilising the replace
function.

I want to be able to send an email address to the email once the vba has
opened it, then replace some data with data from a MS Access form which is
where the vba is going to be initiated from.

Could you help at all?

Simon

"Sue Mosher [MVP]" wrote:

17.4.2 - Creating a message from a boilerplate template

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


"Simon Hughes (ICSNET UK)"
wrote in message ...
Hi Sue,

I appreciate your reply. I have just bought your book from Amazon am I am
expecting deliver on Thursday. Hopefully I can learn a thing or two from
it !!

Which part of the book contains the sample code relating to my query?

Simon

"Sue Mosher [MVP]" wrote:

To create a new message from an .oft file, use the Outlook object model's
Application.CreateItemFromTemplate() method, passing the path to the .oft
file as the argument.

Replace() works the same no matter what text you use it on:

updatedText = Replace(originalText, findText, replaceText)

If you have problems making that work with your variables, post your
existing code.

There's a detailed example in my book, which is available on Google
Books.

"Simon Hughes (ICSNET UK)"

wrote in message
...
Hi Sue,

Thanks for your reply, very helpful.

However, I am quite new to VBA and I am a little unsure of how to code
the
Replace() function and how to call the oft templete to open and inset
the
email address.

I ok with calling a new email message and sending the to,cc,bbc,
subject
and
body and even HTMLBody although not sure of the replace function.

"Sue Mosher [MVP]" wrote:

An Outlook .oft file doesn't have bookmarks. You have two choices
he

1) Use a Word document as the starting point, and use the code
technique
shown at http://www.outlookcode.com/codedetail.aspx?id=1333 to
generate
the
email messages.

-or-

2) Use placeholder text in your .oft file to mark the locations where
you
want to replace that placeholder text with, for example, the date and
time.

#2 is easier. Just call the Replace() function on the item's HTMLBody
property as needed.

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


"Simon Hughes (ICSNET UK)" Simon Hughes (ICSNET
wrote in message
...
I run a small home run I.T. Support company any have developed an
Access
2007
database for all our business activities. I currently send email
using
a
VBA
script although it does not allow me to be as flexible as I would
like.

I often send emails to customers where I would like to have a good
looking
email, as I have created an outlook template (oft) with our logo and
the
formatting just as I want it.

An example of our requirement is to be able to add a time and date
value
from an access form into one of these templates, along with
initially
opening
the template, then adding the email address again from a record
value
in
the
access form.

My idea was to do it in a similar way to how we achieve sending data
to
a
Word 2007 template - by using bookmarks. This would allow us to
preformat
the
standard emails in a oft template file and then simply drop the
required
data
from the Access form into it at the bookmark locations.
Do you know where I can go with this, as I've spent hours crawling
the
forums and have hit a wall!!

Look forward to your reply.


.



.



.

Do you have some particular questions? If not, then perhaps you should
implement the specific example in the book and step through its code in the
debugger, so you can get a better sense of how it all comes together.
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Simon Hughes (ICSNET UK)"
wrote in message ...
Hi Sue,

I have been reading through your book although I seem unable to grasp the
idea of writing the VBA for opening a oft file and utilising the replace
function.

I want to be able to send an email address to the email once the vba has
opened it, then replace some data with data from a MS Access form which is
where the vba is going to be initiated from.

Could you help at all?

Simon

"Sue Mosher [MVP]" wrote:

17.4.2 - Creating a message from a boilerplate template

"Simon Hughes (ICSNET UK)"

wrote in message
...
Hi Sue,

I appreciate your reply. I have just bought your book from Amazon am I
am
expecting deliver on Thursday. Hopefully I can learn a thing or two
from
it !!

Which part of the book contains the sample code relating to my query?

Simon

"Sue Mosher [MVP]" wrote:

To create a new message from an .oft file, use the Outlook object
model's
Application.CreateItemFromTemplate() method, passing the path to the
.oft
file as the argument.

Replace() works the same no matter what text you use it on:

updatedText = Replace(originalText, findText, replaceText)

If you have problems making that work with your variables, post your
existing code.

There's a detailed example in my book, which is available on Google
Books.

"Simon Hughes (ICSNET UK)"

wrote in message
...
Hi Sue,

Thanks for your reply, very helpful.

However, I am quite new to VBA and I am a little unsure of how to
code
the
Replace() function and how to call the oft templete to open and
inset
the
email address.

I ok with calling a new email message and sending the to,cc,bbc,
subject
and
body and even HTMLBody although not sure of the replace function.

"Sue Mosher [MVP]" wrote:

An Outlook .oft file doesn't have bookmarks. You have two choices
he

1) Use a Word document as the starting point, and use the code
technique
shown at http://www.outlookcode.com/codedetail.aspx?id=1333 to
generate
the
email messages.

-or-

2) Use placeholder text in your .oft file to mark the locations
where
you
want to replace that placeholder text with, for example, the date
and
time.

#2 is easier. Just call the Replace() function on the item's
HTMLBody
property as needed.

"Simon Hughes (ICSNET UK)" Simon Hughes (ICSNET
wrote in message
...
I run a small home run I.T. Support company any have developed an
Access
2007
database for all our business activities. I currently send email
using
a
VBA
script although it does not allow me to be as flexible as I would
like.

I often send emails to customers where I would like to have a
good
looking
email, as I have created an outlook template (oft) with our logo
and
the
formatting just as I want it.

An example of our requirement is to be able to add a time and
date
value
from an access form into one of these templates, along with
initially
opening
the template, then adding the email address again from a record
value
in
the
access form.

My idea was to do it in a similar way to how we achieve sending
data
to
a
Word 2007 template - by using bookmarks. This would allow us to
preformat
the
standard emails in a oft template file and then simply drop the
required
data
from the Access form into it at the bookmark locations.
Do you know where I can go with this, as I've spent hours
crawling
the
forums and have hit a wall!!

Look forward to your reply.

Hi Sue,

Sorry for the unclear question.

What I was getting at was, the article in the book seemed to be aimed at
programatically replying to an email already received rather than generating
a new message from VBA in Access and inserting data from the DB into the
email template that I somehow need to open from VBA.

Hope this is a little clearer.

Regards,

Simon Hughes
ICSNET UK
t: 01495 70 80 90
m: 07747 41 41 41



"Sue Mosher [MVP]" wrote:

Do you have some particular questions? If not, then perhaps you should
implement the specific example in the book and step through its code in the
debugger, so you can get a better sense of how it all comes together.
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Simon Hughes (ICSNET UK)"
wrote in message ...
Hi Sue,

I have been reading through your book although I seem unable to grasp the
idea of writing the VBA for opening a oft file and utilising the replace
function.

I want to be able to send an email address to the email once the vba has
opened it, then replace some data with data from a MS Access form which is
where the vba is going to be initiated from.

Could you help at all?

Simon

"Sue Mosher [MVP]" wrote:

17.4.2 - Creating a message from a boilerplate template

"Simon Hughes (ICSNET UK)"

wrote in message
...
Hi Sue,

I appreciate your reply. I have just bought your book from Amazon am I
am
expecting deliver on Thursday. Hopefully I can learn a thing or two
from
it !!

Which part of the book contains the sample code relating to my query?

Simon

"Sue Mosher [MVP]" wrote:

To create a new message from an .oft file, use the Outlook object
model's
Application.CreateItemFromTemplate() method, passing the path to the
.oft
file as the argument.

Replace() works the same no matter what text you use it on:

updatedText = Replace(originalText, findText, replaceText)

If you have problems making that work with your variables, post your
existing code.

There's a detailed example in my book, which is available on Google
Books.

"Simon Hughes (ICSNET UK)"

wrote in message
...
Hi Sue,

Thanks for your reply, very helpful.

However, I am quite new to VBA and I am a little unsure of how to
code
the
Replace() function and how to call the oft templete to open and
inset
the
email address.

I ok with calling a new email message and sending the to,cc,bbc,
subject
and
body and even HTMLBody although not sure of the replace function.

"Sue Mosher [MVP]" wrote:

An Outlook .oft file doesn't have bookmarks. You have two choices
he

1) Use a Word document as the starting point, and use the code
technique
shown at http://www.outlookcode.com/codedetail.aspx?id=1333 to
generate
the
email messages.

-or-

2) Use placeholder text in your .oft file to mark the locations
where
you
want to replace that placeholder text with, for example, the date
and
time.

#2 is easier. Just call the Replace() function on the item's
HTMLBody
property as needed.

"Simon Hughes (ICSNET UK)" Simon Hughes (ICSNET
wrote in message
...
I run a small home run I.T. Support company any have developed an
Access
2007
database for all our business activities. I currently send email
using
a
VBA
script although it does not allow me to be as flexible as I would
like.

I often send emails to customers where I would like to have a
good
looking
email, as I have created an outlook template (oft) with our logo
and
the
formatting just as I want it.

An example of our requirement is to be able to add a time and
date
value
from an access form into one of these templates, along with
initially
opening
the template, then adding the email address again from a record
value
in
the
access form.

My idea was to do it in a similar way to how we achieve sending
data
to
a
Word 2007 template - by using bookmarks. This would allow us to
preformat
the
standard emails in a oft template file and then simply drop the
required
data
from the Access form into it at the bookmark locations.
Do you know where I can go with this, as I've spent hours
crawling
the
forums and have hit a wall!!

Look forward to your reply.


.

Sue's off for a few days.

To create a brand new blank email item and have a reference available to it
for adding data from a DB your code would start like this, assuming you have
an Outlook.Application object oOL:

Dim oMail As Outlook.MailItem
Set oMail = oOL.CreateItem(olMailItem)

You then add whatever properties you want from the DB information such as
Subject or Body or HTMLBody, etc. You can get the Recipients collection of
the mail item and add one or more recipients to that, etc.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"Simon Hughes (ICSNET UK)"
wrote in message ...
Hi Sue,

Sorry for the unclear question.

What I was getting at was, the article in the book seemed to be aimed at
programatically replying to an email already received rather than
generating
a new message from VBA in Access and inserting data from the DB into the
email template that I somehow need to open from VBA.

Hope this is a little clearer.

Regards,

Simon Hughes
ICSNET UK
t: 01495 70 80 90
m: 07747 41 41 41