Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Caroline
 
Posts: n/a
Default Merge Switch Question

As the result of a recent upgrade to our company database software I need
to reformat a number of the merge documents that information is pulled into.
When a user sets up an appointment it is done via this software, and part of
this includes the duration of the appointment. Formerly, the software created
a CSV file that showed this as a duration in hours and minuets e.g. 2h 45m
but apparently this was causing problems for some customers and if now just
creates a CSV file containing the duration in minute format, regardless of
duration. Since some of our appointments last a number of hours, its really
not suitable to put in 165 minutes in a letter.

Im using date switches in another part of the letters, but I cant figure
out how to devise a suitable switch to format this number string into a
format where is displays as something like 1h 45mins instead of just the
number of minuets. Im sure there should be a way round this, but I just
cant find it.

Any suggestions would be very helpful.
 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge Question NKYBred Microsoft Word Help 0 October 5th 05 03:11 PM
Mail merge question ? simplym Mailmerge 1 August 3rd 05 10:13 PM
mail merge with attachments AS Mailmerge 5 April 9th 05 09:49 AM
Can I use merge to create 3x5 question and answer flash cards? colleen New Users 1 February 4th 05 10:39 AM
merge with excel question Cowtoon Mailmerge 1 December 7th 04 10:51 AM


All times are GMT +1. The time now is 12:43 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"