HTML Stationery with Word as Email Editor 2003

[Janine_docsonline]

Hi, client uses 2003 and Merges Access data into Word templates. Then wants to send HTML emails.

In need of options or to be put on right track. I assume one just sends the Word document as a HTML format (web). So you still have a word document you created with Access and Word template and then send the saved .doc as HTML format. He wants to see his letterhead (template) as it appears in Word in his email as the letterhead stationery and of course in HTML you cannot cut and paste.

Any steps as to the right approach to achieve this seamlessly would be appreciated. We still will be using Access to populate Word template so the template still is not in Outlook 2003.

What do others do?

Regards and thank you in advance..

 

[Sue Mosher [MVP-Outlook]]

You may have a couple of options:

1) Can the process be automated as a straightforward Word mail merge to HTML-format email?

2) If a merge process is not feasible, Word 2003 supports a method for sending a document as an email message:

Set myItem = myDocument.MailEnvelope.Item
myItem.To = "(e-mail address removed)"
myItem.Subject = "some subject"
myItem.Send

Note, however, that this method will trigger a security prompt for each send. Working around that would require a third-party tool; see http://www.outlookcode.com/d/sec.htm
--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers



Hi, client uses 2003 and Merges Access data into Word templates. Then wants to send HTML emails.

In need of options or to be put on right track. I assume one just sends the Word document as a HTML format (web). So you still have a word document you created with Access and Word template and then send the saved .doc as HTML format. He wants to see his letterhead (template) as it appears in Word in his email as the letterhead stationery and of course in HTML you cannot cut and paste.

Any steps as to the right approach to achieve this seamlessly would be appreciated. We still will be using Access to populate Word template so the template still is not in Outlook 2003.

What do others do?

Regards and thank you in advance..

 

[Janine_docsonline]

Either way. 1st option normal merge but using a macro to select record set
is feasible. How automated can I be- select record set from Access, save
document then email or do you mean merge to HTML email directly? Can I
macro the entire procedure?

Can I select email address from Access in the second option? Is the second
option HTML when it attaches the letterhead doc with logo and tables etc?
Yes I know the dialogue box and will have a look. If I invoke your macro
whilst in the document to send is that okay?

Thank you Sue for assistance.

You may have a couple of options:

1) Can the process be automated as a straightforward Word mail merge to
HTML-format email?

2) If a merge process is not feasible, Word 2003 supports a method for
sending a document as an email message:

Set myItem = myDocument.MailEnvelope.Item
myItem.To = "(e-mail address removed)"
myItem.Subject = "some subject"
myItem.Send

Note, however, that this method will trigger a security prompt for each
send. Working around that would require a third-party tool; see
http://www.outlookcode.com/d/sec.htm
--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers



Hi, client uses 2003 and Merges Access data into Word templates. Then wants
to send HTML emails.

In need of options or to be put on right track. I assume one just sends the
Word document as a HTML format (web). So you still have a word document you
created with Access and Word template and then send the saved .doc as HTML
format. He wants to see his letterhead (template) as it appears in Word in
his email as the letterhead stationery and of course in HTML you cannot cut
and paste.

Any steps as to the right approach to achieve this seamlessly would be
appreciated. We still will be using Access to populate Word template so the
template still is not in Outlook 2003.

What do others do?

Regards and thank you in advance..

 

[Sue Mosher [MVP-Outlook]]

I mean merge directly, either from an Access query or from a data set that you save as a separate document. Word mail merge can be fully automated. I'm sure a Google search will turn up sample code. Email is one of the outputs, along with new document and printer. You will need to specify HTML as the email format option to avoid security prompts.

In the second option, you'd replace the "(e-mail address removed)" with a variable that your application would set, using the Access data. The message is always generated in HTML. You can try it for yourself without writing code by using the File | Send To | Mail Recipient command in one of your Word documents.


--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Janine_docsonline]

Thank you Sue for guidance - makes it a bit easier. I have tested the email
and it works fine.

I mean merge directly, either from an Access query or from a data set that
you save as a separate document. Word mail merge can be fully automated. I'm
sure a Google search will turn up sample code. Email is one of the outputs,
along with new document and printer. You will need to specify HTML as the
email format option to avoid security prompts.

In the second option, you'd replace the "(e-mail address removed)" with a
variable that your application would set, using the Access data. The message
is always generated in HTML. You can try it for yourself without writing
code by using the File | Send To | Mail Recipient command in one of your
Word documents.


--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers