P
Paul Linton
My company has information about each of its products
stored in a database. When using Word as an e-mail editor
I would like to be able to click a button that then allows
me to select a product and have an information sheet
attached to the current e-mail.
I can do this interactively by clicking on the paperclip
button in the email header and browsing for a file. But
the macro recorder does not record this action.
So how do I use VBA to add an attachment to a mail
message? (Note, I want the current Word document sent as
the body of the email and to add my product information
sheets as attachments, not just send the current document
as an attachment).
TIA
Paul
stored in a database. When using Word as an e-mail editor
I would like to be able to click a button that then allows
me to select a product and have an information sheet
attached to the current e-mail.
I can do this interactively by clicking on the paperclip
button in the email header and browsing for a file. But
the macro recorder does not record this action.
So how do I use VBA to add an attachment to a mail
message? (Note, I want the current Word document sent as
the body of the email and to add my product information
sheets as attachments, not just send the current document
as an attachment).
TIA
Paul