+ Reply to Thread
Results 1 to 5 of 5

Data from one file excel to outlook

  1. #1
    Registered User
    Join Date
    10-13-2014
    Location
    torino
    MS-Off Ver
    2013
    Posts
    3

    Data from one file excel to outlook

    Hi guys,

    i'm not a good user of excel so i'm asking you to help me.

    i have one file excel (called 7x24.xlsx), it contains a lot of name of the people that should travel and i have to send they an email with an advise.
    everyday my colleague update it with new names (he put near the name an update date.. for example if today is 1/5/15 : one column (A1) with the name: Rossi Mario, one column (B1) with the start date of the travel :02/05/15 and another column (C1) that indicate the date of the insert into the file :01/05/2015).
    When the file is updated, i'll check the new people inside the file and i send an email to all the travellers.

    every week is like this for me:
    on Monday I send an email to people who start the travel on Thursday of the same week (i copy all the travellers name from the excel file and i paste this name into Outlook)
    on tuesday i send an email to people who start the travel on Friday of the same week
    on wednesday i send an email to people who star the travel on saturday and sunday of the same week
    on Thursday i send an email to people who start the travel on Monday e Tuesday of the nex week
    on Friday i send an email to peolpe who start the traver on Wednesday of the next week.

    Using this method i find an error.. (for example) if is tuesday and my collegue has just update the file with new Thursday travellers, i don't sent the email to them but only for friday travellers and doing like this all the new name for thursday are lost.
    since I realized the error, I have to check every time all the latest send emails and check if other people have been included.

    can you help with a new method? or a specific option of Outlook/Excel that helps me?

    Thank to all for the support.
    Andrea.

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Data from one file excel to outlook

    like that___________
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    10-13-2014
    Location
    torino
    MS-Off Ver
    2013
    Posts
    3

    Re: Data from one file excel to outlook

    can you explain that please?

    thanks

  4. #4
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Data from one file excel to outlook

    explain? how? You've not even attached an excel file.
    Quaerite et invenietis

  5. #5
    Registered User
    Join Date
    10-13-2014
    Location
    torino
    MS-Off Ver
    2013
    Posts
    3

    Re: Data from one file excel to outlook

    7_24.xlsx this my test file..


    please help me..
    Last edited by elkarmo; 05-01-2015 at 03:28 AM. Reason: wrong file

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 01-20-2015, 10:07 PM
  2. copy data from outlook attached excel file into a local one
    By s_samira_21 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-17-2014, 03:36 PM
  3. Replies: 4
    Last Post: 05-01-2014, 09:36 AM
  4. Can't open Excel file in Outlook
    By ALEZI in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 02-22-2014, 04:49 AM
  5. Exporting Excel data into Outlook calendars: Changing an Outlook VBA to Excel VBA
    By spaceporker in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-19-2012, 11:39 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1