| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create a Command Button to Send E-Mails to selected recipients
I have an excel file that I send weekly to some Managers. Currently, I copy
and paste a list of e-mail addresses in a new Outlook message and then send the file. I wanted to create a Command Button, but I can't create the VBA code to send the excel file via Outlook. Can I get some help please? thanks, meme |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Create a Command Button to Send E-Mails to selected recipients
Hi MeMe
You find all the code you need on this page (click also on the Tip page link on each example page0 http://www.rondebruin.nl/sendmail.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "MeMe" wrote in message ... I have an excel file that I send weekly to some Managers. Currently, I copy and paste a list of e-mail addresses in a new Outlook message and then send the file. I wanted to create a Command Button, but I can't create the VBA code to send the excel file via Outlook. Can I get some help please? thanks, meme |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Create a Command Button to Send E-Mails to selected recipients
Hi Ron,
thank you for your link. It helped out a lot. I have another, hopefully quick, question: can I add an auto signature to this macro? The trick is that there are multiple signatures that could be chosen and I would want the signature to appear after the icon. Lastly, when I type the text for the body, it is to the left of the icon and I would like to have the intro sentence on the first line saying here is your weekly file, then the icon underneath the intro, then our department signature underneath the icon kinda idea. Opps, one more, what is the best way to protect a macro from being viewed/changed? Appreciate any help you can offer. "Ron de Bruin" wrote: Hi MeMe You find all the code you need on this page (click also on the Tip page link on each example page0 http://www.rondebruin.nl/sendmail.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "MeMe" wrote in message ... I have an excel file that I send weekly to some Managers. Currently, I copy and paste a list of e-mail addresses in a new Outlook message and then send the file. I wanted to create a Command Button, but I can't create the VBA code to send the excel file via Outlook. Can I get some help please? thanks, meme |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Create a Command Button to Send E-Mails to selected recipients
See
http://www.rondebruin.nl/mail/folder3/signature.htm Lastly, when I type the text for the body, it is to the left of the icon What do you mean with icon Do you use a old version of Outlook -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "MeMe" wrote in message ... Hi Ron, thank you for your link. It helped out a lot. I have another, hopefully quick, question: can I add an auto signature to this macro? The trick is that there are multiple signatures that could be chosen and I would want the signature to appear after the icon. Lastly, when I type the text for the body, it is to the left of the icon and I would like to have the intro sentence on the first line saying here is your weekly file, then the icon underneath the intro, then our department signature underneath the icon kinda idea. Opps, one more, what is the best way to protect a macro from being viewed/changed? Appreciate any help you can offer. "Ron de Bruin" wrote: Hi MeMe You find all the code you need on this page (click also on the Tip page link on each example page0 http://www.rondebruin.nl/sendmail.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "MeMe" wrote in message ... I have an excel file that I send weekly to some Managers. Currently, I copy and paste a list of e-mail addresses in a new Outlook message and then send the file. I wanted to create a Command Button, but I can't create the VBA code to send the excel file via Outlook. Can I get some help please? thanks, meme |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Create a Command Button to Send E-Mails to selected recipients
Hi Ron,
am checking out what you sent me. Outlook is 2003 and what I mean by icon is the excel file attachement image. So my comments go to the left of this icon and it is like the text and the picture is on the same "line" in Outlook. "Ron de Bruin" wrote: See http://www.rondebruin.nl/mail/folder3/signature.htm Lastly, when I type the text for the body, it is to the left of the icon What do you mean with icon Do you use a old version of Outlook -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "MeMe" wrote in message ... Hi Ron, thank you for your link. It helped out a lot. I have another, hopefully quick, question: can I add an auto signature to this macro? The trick is that there are multiple signatures that could be chosen and I would want the signature to appear after the icon. Lastly, when I type the text for the body, it is to the left of the icon and I would like to have the intro sentence on the first line saying here is your weekly file, then the icon underneath the intro, then our department signature underneath the icon kinda idea. Opps, one more, what is the best way to protect a macro from being viewed/changed? Appreciate any help you can offer. "Ron de Bruin" wrote: Hi MeMe You find all the code you need on this page (click also on the Tip page link on each example page0 http://www.rondebruin.nl/sendmail.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "MeMe" wrote in message ... I have an excel file that I send weekly to some Managers. Currently, I copy and paste a list of e-mail addresses in a new Outlook message and then send the file. I wanted to create a Command Button, but I can't create the VBA code to send the excel file via Outlook. Can I get some help please? thanks, meme |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Create a Command Button to Send E-Mails to selected recipients
Do you say that the attacment icon is in the body and not in a seperate line above you body ?
-- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "MeMe" wrote in message ... Hi Ron, am checking out what you sent me. Outlook is 2003 and what I mean by icon is the excel file attachement image. So my comments go to the left of this icon and it is like the text and the picture is on the same "line" in Outlook. "Ron de Bruin" wrote: See http://www.rondebruin.nl/mail/folder3/signature.htm Lastly, when I type the text for the body, it is to the left of the icon What do you mean with icon Do you use a old version of Outlook -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "MeMe" wrote in message ... Hi Ron, thank you for your link. It helped out a lot. I have another, hopefully quick, question: can I add an auto signature to this macro? The trick is that there are multiple signatures that could be chosen and I would want the signature to appear after the icon. Lastly, when I type the text for the body, it is to the left of the icon and I would like to have the intro sentence on the first line saying here is your weekly file, then the icon underneath the intro, then our department signature underneath the icon kinda idea. Opps, one more, what is the best way to protect a macro from being viewed/changed? Appreciate any help you can offer. "Ron de Bruin" wrote: Hi MeMe You find all the code you need on this page (click also on the Tip page link on each example page0 http://www.rondebruin.nl/sendmail.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "MeMe" wrote in message ... I have an excel file that I send weekly to some Managers. Currently, I copy and paste a list of e-mail addresses in a new Outlook message and then send the file. I wanted to create a Command Button, but I can't create the VBA code to send the excel file via Outlook. Can I get some help please? thanks, meme |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Create a Command Button to Send E-Mails to selected recipients
hi Ron,
my Command Button doesn't work anymore. I have to run the macro from the menu. I can't even right-click to get to format our properties. I don't know what I did, but I did try to get that signature to work. Help, please. "Ron de Bruin" wrote: See http://www.rondebruin.nl/mail/folder3/signature.htm Lastly, when I type the text for the body, it is to the left of the icon What do you mean with icon Do you use a old version of Outlook -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "MeMe" wrote in message ... Hi Ron, thank you for your link. It helped out a lot. I have another, hopefully quick, question: can I add an auto signature to this macro? The trick is that there are multiple signatures that could be chosen and I would want the signature to appear after the icon. Lastly, when I type the text for the body, it is to the left of the icon and I would like to have the intro sentence on the first line saying here is your weekly file, then the icon underneath the intro, then our department signature underneath the icon kinda idea. Opps, one more, what is the best way to protect a macro from being viewed/changed? Appreciate any help you can offer. "Ron de Bruin" wrote: Hi MeMe You find all the code you need on this page (click also on the Tip page link on each example page0 http://www.rondebruin.nl/sendmail.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "MeMe" wrote in message ... I have an excel file that I send weekly to some Managers. Currently, I copy and paste a list of e-mail addresses in a new Outlook message and then send the file. I wanted to create a Command Button, but I can't create the VBA code to send the excel file via Outlook. Can I get some help please? thanks, meme |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Create a Command Button to Send E-Mails to selected recipients
Do you have a formas burron or a control toolbox button on your sheet ?
-- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "MeMe" wrote in message ... hi Ron, my Command Button doesn't work anymore. I have to run the macro from the menu. I can't even right-click to get to format our properties. I don't know what I did, but I did try to get that signature to work. Help, please. "Ron de Bruin" wrote: See http://www.rondebruin.nl/mail/folder3/signature.htm Lastly, when I type the text for the body, it is to the left of the icon What do you mean with icon Do you use a old version of Outlook -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "MeMe" wrote in message ... Hi Ron, thank you for your link. It helped out a lot. I have another, hopefully quick, question: can I add an auto signature to this macro? The trick is that there are multiple signatures that could be chosen and I would want the signature to appear after the icon. Lastly, when I type the text for the body, it is to the left of the icon and I would like to have the intro sentence on the first line saying here is your weekly file, then the icon underneath the intro, then our department signature underneath the icon kinda idea. Opps, one more, what is the best way to protect a macro from being viewed/changed? Appreciate any help you can offer. "Ron de Bruin" wrote: Hi MeMe You find all the code you need on this page (click also on the Tip page link on each example page0 http://www.rondebruin.nl/sendmail.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "MeMe" wrote in message ... I have an excel file that I send weekly to some Managers. Currently, I copy and paste a list of e-mail addresses in a new Outlook message and then send the file. I wanted to create a Command Button, but I can't create the VBA code to send the excel file via Outlook. Can I get some help please? thanks, meme |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Create a Command Button to Send E-Mails to selected recipients
With your workbook open and VBE project explorer open, right-clcik on your
Project/workbook and "Project PropertiesProtectionLock for viewing and give a password. DO NOT forget password. Save and close the workbook before protection will take place. Gord Dibben MS Excel MVP On Sun, 27 Jan 2008 12:10:01 -0800, MeMe wrote: Opps, one more, what is the best way to protect a macro from being viewed/changed? |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Create a Command Button to Send E-Mails to selected recipients
Thanks Gord
I missed that one -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Gord Dibben" <gorddibbATshawDOTca wrote in message ... With your workbook open and VBE project explorer open, right-clcik on your Project/workbook and "Project PropertiesProtectionLock for viewing and give a password. DO NOT forget password. Save and close the workbook before protection will take place. Gord Dibben MS Excel MVP On Sun, 27 Jan 2008 12:10:01 -0800, MeMe wrote: Opps, one more, what is the best way to protect a macro from being viewed/changed? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Command Button - Macro to print to pdf, then send pdf to email. | Excel Discussion (Misc queries) | |||
| Send Open Spreadsheet using Command button | Excel Discussion (Misc queries) | |||
| send mails from excel | Excel Discussion (Misc queries) | |||
| Send multiple e-mails with excel | Excel Discussion (Misc queries) | |||
| i am not getting any e mails when clicking rec/send how do i re | Excel Discussion (Misc queries) | |||
Hybrid Mode
