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
 
R

rst75

So you want to keep resending the same message, adding the next days data to it?
 

Pranesh

New Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
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?
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
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.
Thread starter Similar threads Forum Replies Date
H Won't save a copy of every piece of sent mail? Using Outlook 7
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 New Slipstick.com Articles 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 New Slipstick.com Articles 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
M Outlook doesn't save sent emails Using Outlook 1
T Outlook 2010 does not save "sent" messages Using Outlook 1
M Outlook 2007 and 'Save sent item To' Other Folder Using Outlook 1
S From Field is blank in sent messages that I set to save to folder other than Sent Items Using Outlook 1
S Not able to SAVE SENT ITEMS to designated folder...stores in my Outbox Using Outlook 2
R save contacts into Business Contact Manager that are sent from Sales reps Using Outlook 0
S When attempting to 'Save Sent Items' to a specific folder, the emails remain in my Outbox - HELP!!! Using Outlook 0
E How to save replies to Sent Items folder with a shared mailbox - Outlook 2010 Using Outlook 3
D Prevent popup of "Do you want to save changes?" when closing after opening an appointment to view Outlook VBA and Custom Forms 0
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
J Save E-mail attachments in a specific folder Outlook VBA and Custom Forms 0
I Outlook 2016 64bit - on receipt convert emails into PDF and save Outlook VBA and Custom Forms 2
V VB script code to save a specific email attachment from a given email Outlook VBA and Custom Forms 14
C Auto save outlook attachments when email is received Outlook VBA and Custom Forms 1
N editing drafts - won't let me save Using Outlook 12
nathandavies Email Details to Excel & Save as .MSG on one macro - combination of 2 macros Outlook VBA and Custom Forms 3
C Need VBA code to automatically save message outside outlook and add date Outlook VBA and Custom Forms 1
Diane Poremsky Save Selected Email Message as .msg File New Slipstick.com Articles 11
Diane Poremsky Export (Save) Outlook Contact photos New Slipstick.com Articles 0
Diane Poremsky Save Messages and Attachments to a New Folder New Slipstick.com Articles 0
B Delete/replace old files and save new attachments Using Outlook 1
E Outlook 2016 and Numerous Prompts to Save Emails Using Outlook 3
Diane Poremsky Save Outlook Email as a PDF New Slipstick.com Articles 0
Diane Poremsky Edit and Save Outlook's Read-Only Attachments New Slipstick.com Articles 0
Similar threads


















































Top