EXCEL VBA - Importing and formating a TXT file to a existing table

Hallo Birgit,

bitte folge den Schritten in der Anleitung und lass uns wissen ob es bei dir geklappt hat! Es ist auf englisch, wenn du Hilfe benötigst kannst du dich ebenfalls melden.

Add iCalendar files into Outlook

iCalendar (or iCal) files are data files that contain details of events including the date, time and location. iCal files can either be opened in Outlook as a new Outlook Calendar (separate from your existing calendars) or the iCal file can be
saved and imported into your existing Outlook Calendar.

• Open an iCal file in Microsoft
  Outlook
• Import an iCal
  file into your Outlook Calendar

Open an iCal file in Microsoft Outlook
Opening an iCal file in Microsoft Outlook will create a new calendar in your Outlook Calendars that contains the events from the iCal file. This calendar will be completely separate from your other Outlook calendars and will exist in Outlook
until you choose to remove it.

To open an iCal file in Outlook:

1. Click on an iCal link on a website
2. When prompted, click Open. The iCalendar will appear in your Outlook Calendar under 'Other Calendars'.
   

Import an iCal file into your Outlook Calendar
If you would like to add information from an iCal file into your Outlook Calendar:

1. Click on an iCal link on a website
2. When prompted, click Save and save the file to your computer
3. Open Microsoft Outlook and go to File >
   Open > Import
4. When prompted select Import an iCalendar (.ics) or vCalendar file (.vcs) and click
   Next
5. When prompted, browse for the iCal file that you saved to your computer and click
   OK (the file will have the file extension of .ics e.g. basics.ics).
6. When prompted, click Import
7. The dates from the iCal file will now be imported into your existing Outlook Calendar

Beste Grüße, dein Microsoft-Team

Hallo HPI_,



"However, the following parameters are required to create an external contact and must be populated:

•ExternalEmailAddress

•Name

•FirstName

•LastName

•OtherTelephone

•Manage



When you’re finished preparing the CSV file, copy it to your desktop. Name it ExternalContacts.csv."



Überprüfe bitte die angeforderten Felder. Verwende bitte die csv Dateivorlage.



"Download
the sample CSV file posted on the Downloads forum on the Office 365 community site. The sample file is actually a .txt file. So open it in Microsoft Excel, and save it as a CSV file. Use commas as the delimiters."

Freue mich auf Deine Rückmeldung.



Mit freundlichen Grüßen,



Desislava Dimova



Microsoft Office 365 Support Engineer

Hallo Pauline,

ich habe geGoogled und bin auf den Power Rules Manager gestoßen:

http://www.sperrysoftware.com/Outlook/power-rules-manager.asp

Laut Produktbeschriebung kann der unter anderem:

• Print Outlook rules

• Save Outlook rules to a plain text file (TXT), a comma delimited file (CSV), or Microsoft® Excel® (XLS) formats

Werde ich zu Hause mal ausprobieren, ob das klappt.

Da man das Programm kaufen muss, weiß ich allerdings nicht, ob die Demoversion das Exportieren und Ausdrucken erlaubt.

Gruß

OLLI

Hello .'ve ever tried to import into an existing table with MEMO fields
. If did does not work, you'll have to realize the import using VBA
Greeting Gunter
- Access FAQs:
http://www.donkarl.com

beim Importieren von CSV oder txt Dateien wird immer ein Autofilter angewendet.

Wie machst Du das denn?
<br />Power Query - How to import a CSV file that does not match your locale - Microsoft Community
<br />Andreas.
<br />