MS word 2007 sending document via email as attachment (keeping formatting)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rob W - 08 Dec 2007 16:15 GMT

Greetings,

I am wanting to send a questionnaire via word (It must keep its formatting
as is full of list box and other controls), so I recorded the macro of using
the word 2007 option to send email

ActiveDocument.SendMail

I then want to add a subject, recipients and even a message would be a nice
bonus! Which I dont think is supported via .SendMail

I googl'd around and found

http://word.mvps.org/FAQs/InterDev/SendMail.htm

The first method roundslip doesnt appear to work as error appears ..

Run-time error '5892';
Method 'HasRoutingSlip' of object '_Document' failed.

The second method cant be applied due to the formattign issue, plus Im sure
it could be done simpler.

Any advice or assistance would be appreciated.

Cheers
Rob W

Reply to this Message

Graham Mayor - 09 Dec 2007 06:54 GMT

The only way you will succeed with this is to send the document as an
attachment as Word Document and HTML have different formatting requirements.
See the article prepared by fellow MVP Doug Robbins at
http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm . However then
you will find that a majority of your potential recipients will not have
Word 2007. Back to the drawing board!

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> Greetings,
>
[quoted text clipped - 23 lines]
> Cheers
> Rob W

Reply to this Message