| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Email
Hi
I am using a macro to drop completed workbooks, or parts of completed workbooks into an email, using Application.Dialogs(xlDialogSendMail).Show. As the various mails are sent to specific groups or department mail box's I would like to have the To: and CC: fields completed automatically. Can this be acheived from the macro run in excel. Thanks Richard |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Email
This dialog takes 3 parameters, recipients, subject and return_receipt.
So you can use Application.Dialogs(xlDialogSendMail).Show ","W ork update" -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Richard" wrote in message ... Hi I am using a macro to drop completed workbooks, or parts of completed workbooks into an email, using Application.Dialogs(xlDialogSendMail).Show. As the various mails are sent to specific groups or department mail box's I would like to have the To: and CC: fields completed automatically. Can this be acheived from the macro run in excel. Thanks Richard |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Email
Apologies I hope I'm not being totally thick, but I now get the following:
Compile error: Expected: line number or label or statement or end of statement "Bob Phillips" wrote: This dialog takes 3 parameters, recipients, subject and return_receipt. So you can use Application.Dialogs(xlDialogSendMail).Show ","W ork update" -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Richard" wrote in message ... Hi I am using a macro to drop completed workbooks, or parts of completed workbooks into an email, using Application.Dialogs(xlDialogSendMail).Show. As the various mails are sent to specific groups or department mail box's I would like to have the To: and CC: fields completed automatically. Can this be acheived from the macro run in excel. Thanks Richard |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Email
Probably wrap-around, try
Application.Dialogs(xlDialogSendMail).Show _ ","W ork update" -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Richard" wrote in message ... Apologies I hope I'm not being totally thick, but I now get the following: Compile error: Expected: line number or label or statement or end of statement "Bob Phillips" wrote: This dialog takes 3 parameters, recipients, subject and return_receipt. So you can use Application.Dialogs(xlDialogSendMail).Show ","W ork update" -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Richard" wrote in message ... Hi I am using a macro to drop completed workbooks, or parts of completed workbooks into an email, using Application.Dialogs(xlDialogSendMail).Show. As the various mails are sent to specific groups or department mail box's I would like to have the To: and CC: fields completed automatically. Can this be acheived from the macro run in excel. Thanks Richard |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Email
That is fantastic and suits me just fine. Thanks very much
"Bob Phillips" wrote: Probably wrap-around, try Application.Dialogs(xlDialogSendMail).Show _ ","W ork update" -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Richard" wrote in message ... Apologies I hope I'm not being totally thick, but I now get the following: Compile error: Expected: line number or label or statement or end of statement "Bob Phillips" wrote: This dialog takes 3 parameters, recipients, subject and return_receipt. So you can use Application.Dialogs(xlDialogSendMail).Show ","W ork update" -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Richard" wrote in message ... Hi I am using a macro to drop completed workbooks, or parts of completed workbooks into an email, using Application.Dialogs(xlDialogSendMail).Show. As the various mails are sent to specific groups or department mail box's I would like to have the To: and CC: fields completed automatically. Can this be acheived from the macro run in excel. Thanks Richard |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Macro how to create email link for the email addresses in aRange or Selection | Excel Worksheet Functions | |||
| how do you email a portion of a worksheet (range) as an insert into the body of an email? | Excel Programming | |||
| can I copy a column of email addresses, paste into email address? | New Users to Excel | |||
| Transfer Email addresses from spreadsheet to email address book | Excel Discussion (Misc queries) | |||
| Email editor closes when forwarding Excel-embedded email | Setting up and Configuration of Excel | |||
Linear Mode
