Software

Ask something
Question Locked

Including message body when emailing mail merged attachments

0 helpful
4 replies

by inschris

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Word 2000, Access 97, Outlook Express 5.5: We succeed in saving and using an MS Word VBA macro to merge name fields from records in an Access database into a Word form letter, then email the output .doc's as attachments to email addresses which are likewise in the Access database. Succeed also manually, without using a macro. The emails appear in the Outbox of Outlook Express.

When using such macro-automated- or manual mail merge, is it possible also to get a uniform, unmerged plain text email message body into the emails?

Both in Word's Tools/Options/General/Email Options, and in the macro, I have tried nominating a predefined signature to be used in new msgs, but that didn't appear in the merged emails.

Thanks to all in anticipation of kind help.

4 replies

by tig2

I know that in Outlook, it is possible to set a number of variable signatures that can be defined to send with every message or selected messages. You should find the path to do that in your Tools > Options menu.

Good luck!

by inschris

Thanks from Capetown, TiggerTwo. Report: I have been able to set a signature to appear in msgs composed in Outlook Express 5.5 or Outlook. However, I have not been able to get this signature to appear in outgoing mail merged msgs, either with Outlook or with Outlook Express 5.5. Thanks nonetheless.

I have seen it done. Possibly via some VBA / macro.

by tig2

A macro. The problem will be that the message is a variable if I recall your original post correctly.

I'm wondering if you can't make it a part of the merge that you're creating. Since you are drawing information from Access tables already, can you create a linked table to hold your various messages and then pull the proper message with the merge?

Or am I missing something?

This discussion is closed to new replies.