Hej.
Jag har en blankett gjord i WORD. När den är ifylld ska den skickas till ett antal personer, alltid samma personer. Den som skickar vet inte vika personer blanketten ska till. Kan man skapa en kommandoknapp och koda så att blanketten skickas till berörda personer när användaren trycker på knappen?
//eva

Det borde fungera. Kan du VBA ?

Ja jag kan VBA. Jag har programmerat en funktion i ACCESS som skickar mail.

Hej! Är också intresserad av detta, men att skicka mail från Excel. Det borde gå till på samma sätt som i Access. Kan du visa mig hur, Eva? Tack! /Peter

Hittade en rätt ordentlig länk

http://www.rondebruin.nl/sendmail.htm

SendMail method Download Example Workbook 1
Mail the whole workbook
Mail one sheet
Mail more then one sheet
Mail Range or Selection
Mail every worksheet with address in A1
Mail a row or rows to each person in a range


Outlook object model (attachment) Download Example Workbook 2
Mail the whole workbook
Mail one sheet
Mail more then one sheet
Mail Range or Selection
Mail every worksheet with address in A1
Mail a different file(s) to each person in a range
Mail chart or chart sheet as picture
Mail a row or rows to each person in a range
Mail Sheet, Sheets, Range or workbook as PDF in Excel 2007 New
Insert Outlook Signature in mail
Zip the Active Workbook and mail it with Outlook


Outlook object model (body) Download Example Workbook 3
Mail one worksheet in the body of the mail
Mail Range/Selection in the body of the mail
Mail selection, range or worksheet in the body of a mail with MailEnvelope
Mail a small message
Mail a message to each person in a range
Mail every worksheet with address in A1 (Body)
Insert Outlook Signature in mail
Mail a row to each person in a range
Mail a row or rows to each person in a range New


Other Tips
Sending mail from Excel with CDO (no security warnings) TIP
Use the Account you want in mail macro in Excel/Outlook 2007 New
Save E-mail attachments to folder
Security (Prevent displaying the dialog to Send or not Send)
Problems with Mailing from Excel
Convert Excel data to Outlook Contacts New
Links to information and articles about mailing in Excel
Send a mail when a cell reaches a certain value
Send a range in the body with Outlook Express

För word fann jag en också, kanske out of date
http://word.mvps.org/FAQs/InterDev/SendMail.htm
http://www.gmayor.com/Extract_Emailed_Data.htm
http://www.febooti.com/products/command-line-email/online-help/send-email-ms-word-macro.html