Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
A macro to send multiple documents to different email address?
Hi, I was wondering if it is possible to create a macro to automate sending
five documents via email. The problem that I think I have, is because every time I would want to send the five documents, the "send to" email address is going to be different every time. Is there a way to define an email address first, then get word to read this address and open up five documents and then send a copy of each to the defined address? I am confused, because I think a macro can do the same thing automatically, but if something has to be different every time, then a macro wont work for me. Thanks in advance. |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
A macro to send multiple documents to different email address?
While it would be possible to create a macro to do it from Word, I would
suggest that you just select the documents in Windows Explorer, then right click and select Send to and then select Mail Recipient. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "SteakCakes" wrote in message ... Hi, I was wondering if it is possible to create a macro to automate sending five documents via email. The problem that I think I have, is because every time I would want to send the five documents, the "send to" email address is going to be different every time. Is there a way to define an email address first, then get word to read this address and open up five documents and then send a copy of each to the defined address? I am confused, because I think a macro can do the same thing automatically, but if something has to be different every time, then a macro wont work for me. Thanks in advance. |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
A macro to send multiple documents to different email address?
Hi,
The right click - send to - mail recipient suggestion isn't exactly what I was looking for. That creates one email with the five documents attached. I am after sending five separate emails with the same functionality of using the "Send to Mail Recipient" button. (As in, right click quick access toolbar - customise quick access Toolbar... - choose commands from: all commands - Send to Mail Recipient" This makes the document the email, rather than an attachment, so the receiver can simply hit "reply", type some answers and press send, instead of confusing them with opening attachments and then re-attaching their saved versions of the document. I hope that makes the situation a little bit clearer. You said that creating a macro is possible? Even though the email address to send each set of documents will change every time? Once again, Thank You for the response. "Doug Robbins - Word MVP" wrote: While it would be possible to create a macro to do it from Word, I would suggest that you just select the documents in Windows Explorer, then right click and select Send to and then select Mail Recipient. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
A macro to send multiple documents to different email address?
It sounds as if you're planning to send this suite of documents to various
people at various times; if so, I'll back out. But if what you want is a mail merge to email with attachments, see http://word.mvps.org/FAQs/MailMerge/...ttachments.htm -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA "SteakCakes" wrote in message ... Hi, I was wondering if it is possible to create a macro to automate sending five documents via email. The problem that I think I have, is because every time I would want to send the five documents, the "send to" email address is going to be different every time. Is there a way to define an email address first, then get word to read this address and open up five documents and then send a copy of each to the defined address? I am confused, because I think a macro can do the same thing automatically, but if something has to be different every time, then a macro wont work for me. Thanks in advance. |
#5
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
A macro to send multiple documents to different email address?
See the article "How to send an email from Word using VBA" at:
http://www.word.mvps.org/FAQs/InterDev/SendMail.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "SteakCakes" wrote in message ... Hi, The right click - send to - mail recipient suggestion isn't exactly what I was looking for. That creates one email with the five documents attached. I am after sending five separate emails with the same functionality of using the "Send to Mail Recipient" button. (As in, right click quick access toolbar - customise quick access Toolbar... - choose commands from: all commands - Send to Mail Recipient" This makes the document the email, rather than an attachment, so the receiver can simply hit "reply", type some answers and press send, instead of confusing them with opening attachments and then re-attaching their saved versions of the document. I hope that makes the situation a little bit clearer. You said that creating a macro is possible? Even though the email address to send each set of documents will change every time? Once again, Thank You for the response. "Doug Robbins - Word MVP" wrote: While it would be possible to create a macro to do it from Word, I would suggest that you just select the documents in Windows Explorer, then right click and select Send to and then select Mail Recipient. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to send email an IP address | Microsoft Word Help | |||
using a macro so send an email | Microsoft Word Help | |||
how do I send my document typed in Word to a email address | Microsoft Word Help | |||
How do I change the email address I use to send mail in outlook? | Microsoft Word Help | |||
Create macro to write email address in email window | Microsoft Word Help |