Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #7  
Old 08-09-2024, 12:50 PM
ShellR ShellR is offline create file name using values from content control fields, then save and send file as attachment Windows 10 create file name using values from content control fields, then save and send file as attachment Office 2019
Novice
create file name using values from content control fields, then save and send file as attachment
 
Join Date: Aug 2024
Posts: 17
ShellR is on a distinguished road
Default

I don't have outlook.
this is the code I tested prior to the code you sent me:
Dim sender_email, email_message, email_message2, reply_address, sender_name As String
Dim Mail As New Message
Dim Cfg As Configuration

On Error GoTo Error_Handling

Set Cfg = Mail.Configuration

'SETUP MAIL CONFIGURATION FIELDS
Cfg(cdoSendUsingMethod) = cdoSendUsingPort
Cfg(cdoSMTPServer) = "SMTP.gmail.com"
Cfg(cdoSMTPServerPort) = 465
Cfg(cdoSMTPAuthenticate) = cdoBasic
Cfg(cdoSMTPUseSSL) = True
Cfg(cdoSendUserName) = "vbatestingtest@gmail.com"
Cfg(cdoSendPassword) = "coding123$$"
Cfg.Fields.Update

'SEND EMAIL
With Mail
.From = "vbatestingtest@gmail.com"
.ReplyTo = "vbatestingtest@gmail.com"
.To = "shellreid2004@yahoo.ca"
.CC = "disegnifenice@gmail.com"
.BCC = " "
.Subject = "testing form send"
.HTMLBody = "testing"
.AddAttachment (strFileB)
' .AddAttachment (strFileD)
.Send
End With
Error_Handling:
If Err.Description <> "" Then MsgBox Err.Description
End Sub
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Save File with specific name from fields input. PM1 Word 17 10-04-2020 07:22 PM
create file name using values from content control fields, then save and send file as attachment Save a .docm file as .pdf and email .pdf as attachment Sydney Lacey Word VBA 2 02-26-2019 07:04 AM
create file name using values from content control fields, then save and send file as attachment Macro to check the existence of a word docx file and create a new word file with specific content. staicumihai Word VBA 14 11-15-2016 01:42 AM
create file name using values from content control fields, then save and send file as attachment Create content control for clip art not a picture from file... swissmiss Drawing and Graphics 3 11-01-2013 05:43 PM
create file name using values from content control fields, then save and send file as attachment Save/Send to file Dawn1231a Outlook 1 08-05-2010 01:10 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:00 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft