How to save sent mail and forward it the next day

Status
Not open for further replies.

Pranesh

New Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
Hi All,

Im new to this forum. Hope you all will help me to find a solution for my problem.

I use Outlook 2010 and daily i need to send production details of my team through mail. I already have the details of production in an excel and once i run my macro it will copy paste the details from excel and send mail to my team.

Now what i want is i want to save the sent mail in my excel and tomorrow once i run the macro it should forward that mail and paste my production details. Then again i want the sent mail to save in my excel by replacing the yesterdays mail so that while tomorrow i run the macro it will be forwarding the latest mail..

Hope some wat i explained my problem. Can anyone please look into this and help me?

Thanks in advance for all your help!!!!

Regards,
Pranesh
 
So you want to keep resending the same message, adding the next days data to it?
 
Yes your right...

I will be using a fresh mail on July 1st and will use that chain mail till July 31st.

The same way each month will be adding new mail and have it for the whole month.

So can you please help?
 
do you want to include the email or just the data to date? Is the excel sheet updated daily with more data? Reading the excel sheet is not big deal - you can either use an excel macro or an outlook macro. if you need to do something with the old message, it may or may not be hard to do.
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
S Outlook (2016 32bit; Gmail IMAP) - Save sent message to Outllook Folder Outlook VBA and Custom Forms 0
C Change default "Save Sent Item To" folder Outlook VBA and Custom Forms 9
D Save Sent Item to Using Outlook 0
Diane Poremsky Choosing the Folder to Save a Sent Message In Using Outlook 0
S Save in folder other than Sent when replying with Quick Steps Using Outlook 5
Diane Poremsky Save Sent Items in Shared Mailbox using an Exchange Server Cmdlet Using Outlook 0
JohnP Shared Mailboxes "Save Sent Item" Using Outlook 2
R How do I 'Save Copy of Sent Item to Folder' for a Shared Mailbox Outlook VBA and Custom Forms 9
D Save sent email in second account not default account? Using Outlook 1
J Save emails in the IMAP sent folder Using Outlook 2
W Save all incomming and sent mails to folder on PC as .msg files Using Outlook 6
G Save emails as msg file from Outlook Web AddIn (Office JS) Outlook VBA and Custom Forms 0
E Outlook 365 Save Selected Email Message as .msg File - oMail.Delete not working when SEARCH Outlook VBA and Custom Forms 0
E Save Selected Email Message as .msg File - digitally sign email doesn't works Outlook VBA and Custom Forms 1
M Outlook Macro to save as Email with a file name format : Date_Timestamp_Sender initial_Email subject Outlook VBA and Custom Forms 0
C Outlook 365 Copy/Save Emails in Folder Outside Outlook to Show Date Sender Recipient Subject in Header Using Outlook 0
W Create a Quick Step or VBA to SAVE AS PDF in G:|Data|Client File Outlook VBA and Custom Forms 1
C Outlook (desktop app for Microsoft365) restarts every time I save my VBA? Using Outlook 1
D VBA Macro to Print and Save email to network location Outlook VBA and Custom Forms 1
N VBA Macro To Save Emails Outlook VBA and Custom Forms 1
N Save emails within a certain date range to network drive Outlook VBA and Custom Forms 0
T Outlook 365 Move newly created tasks automatically on save. Outlook VBA and Custom Forms 1
G Save attachment run a script rule Outlook VBA and Custom Forms 0
N Save Selected Email Message as .msg File Outlook VBA and Custom Forms 12
G Save and Rename Outlook Email Attachments Outlook VBA and Custom Forms 0
G VBA to save selected Outlook msg with new name in selected network Windows folder Outlook VBA and Custom Forms 1
D Outlook 2016 64bit, Cannot Save in 'HTML', format Using Outlook 1
N Save selected messages VBA does not save replies and/or messages that contain : in subject Outlook VBA and Custom Forms 1
L Macro to add Date & Time etc to "drag to save" e-mails Outlook VBA and Custom Forms 17
S save attachment with date & time mentioned inside the file Outlook VBA and Custom Forms 0
S Add VBA save code Using Outlook 0
A Edit attachment Save and Reply Outlook VBA and Custom Forms 0
P Outlook pst file is too huge with POP3. How to save more space? Using Outlook 4
D Prevent popup of "Do you want to save changes?" when closing after opening an appointment to view Outlook VBA and Custom Forms 2
A Unable to save recurring Meeting to Documents folder due to error Using Outlook 2
M Outlook 2013 Script Assistance - Save Opened Link with Subject Added Outlook VBA and Custom Forms 1
R Use an ItemAdd to Save Attachments on Arrival Outlook VBA and Custom Forms 0
W Outlook Calendar does not save view any longer! Using Outlook 3
S automate save the .xlxs file to share Network Using Outlook 1
S save email from excel Outlook VBA and Custom Forms 1
Y Open and Save Hyperlink Files in multiple emails Outlook VBA and Custom Forms 9
9 Outlook 2016 How to save an Outlook attachment to a specific folder then delete the email it came from? Using Outlook 1
O Save attachments using hotkey without changing attributes Outlook VBA and Custom Forms 1
geofferyh Cannot get Macro to SAVE more than one message attachment??? Outlook VBA and Custom Forms 5
N Open & Save VBAProject.Otm using VBA Code Outlook VBA and Custom Forms 1
R VBA | Chosing path to save file Outlook VBA and Custom Forms 1
W Save and rename outlook email attachments to include domain name & date received Outlook VBA and Custom Forms 4
V Change default default save location to Quick Access Using Outlook 1
W Save Outlook attachment in network folder and rename to current date and time Outlook VBA and Custom Forms 18
C Outlook - cannot save subject line changes Using Outlook 2

Similar threads

Back
Top