MailMerge

Chris424 · #1 11-11-2011, 06:02 AM

Hello,

I have a mailmerge which pulls data from a spreadsheet. It shows the outages of services. So if a service is down from 14:00 to 14:30 the duration is 0:30. This displays fine in excel (format [h]:mm) but when I pull this into a mailmerge it shows 12:30 instead of 0:30.

I have tried defining the format in the mailmerge itself but cannot get around this?

Code:

MERGEFIELD Time_to_resolve_hhmm\@"[h]:mm" \*Mergeformat

I have attached the spreadsheet and mailmerge

Can anyone help?

macropod · #2 11-13-2011, 05:10 AM

Hi Chris,

With your workbook, change the formula in H3 to:
=IF(G3="","Unknown",TEXT(G3-F3,"h:mm"))
With the mailmerge main document, delete the '\* Mergeformat' switches. You shouldn't need a switch for the Time_to_resolve_hhmm field.

Chris424 · #3 11-17-2011, 05:51 AM

Quote:

Originally Posted by macropod

Hi Chris,

With your workbook, change the formula in H3 to:
=IF(G3="","Unknown",TEXT(G3-F3,"h:mm"))
With the mailmerge main document, delete the '\* Mergeformat' switches. You shouldn't need a switch for the Time_to_resolve_hhmm field.

That worked perfectly! Thank you so much for your help

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Hyperlink in MailMerge	samndi	Mail Merge	11	12-14-2011 01:59 PM
Mailmerge	dkub	Mail Merge	35	12-07-2011 11:35 PM
Meeting Appointment Not Showing Local Time	april	Outlook	2	06-23-2011 08:57 AM
Add a period of time to a referenced "Time" cell?	derelyth	Excel	4	03-27-2011 04:31 PM
Help with mailmerge???	foxtrot1981	Mail Merge	0	12-03-2010 08:21 AM