Email Mail Merge as Attachment with Body Text

[marka87uk]

Hi,

I have a form in Word 2003 which is mail-merged from an Excel 2003 file with receipient-specific details on.

I wish to email this as an attachment which works fine, but I would like to have body text also. I require a generic message, e.g. "Please see your form attached.".

Is there an easy way to do this?

Thanks

 

[Trevor G]

Do you want VBA to do this from Excel then use something like this

Sub sendForApproval()
'*************************************************************
'The following code has been created to send an email request
'To gain access to the database, References must be set
'To use Outlook, Tools Menu and References
'VBA Code created by Trevor G August 2010
'Contact via mobile
'Email trevorg@
'**************************************************************
Dim olApp As Outlook.Application
Dim olMail As MailItem
Set olApp = New Outlook.Application
Set olMail = olApp.CreateItem(olMailItem)
With olMail
.To = ""
.Subject = "Database - Access Request"
.Body = "Please can you provide access to the Database system." & vbCr & vbCr & _
"The required details are as follows: " & vbCr & vbCr & _
"Full Name is: " & vbCr & _
"My User ID is: " & vbCr & _
"My required access level is (Please delete as applicable (leave the number and position) - 1 Administrator, 2 Updating Only, 1 Manager, 3 Other (Please state))" & vbCr & _
" "
.Display

End With
Set olMail = Nothing
Set olApp = Nothing
End Sub

 

[marka87uk]

Thanks Trevor, that's great but I need to be able to send the recipient-specific Word form with each email as an attachment.

I wish to have body text sent in the emails also otherwise the email would just be blank apart from the subject and attachment.

Hope you can see what I'm intending to do?

 

[Trevor G]

The sample was a guide.

To attach documents you need to use

.Attachments "Path.doc"

Look at this website

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

Take a look at datapig website there is a video that will deal with this for you.

http://www.datapigtechnologies.com/ExcelMain.htm

Scroll down the list until you come to Using Excel Macros